SQL Where Statement Question

Results 1 to 2 of 2

Thread: SQL Where Statement Question

  1. #1
    Join Date
    Dec 1969

    Default SQL Where Statement Question

    Hi,<BR><BR>I have a problem, if I have a SQL statement and would to add another condition on the WHERE field from 2 (Name & country) to 3 is it possible?<BR><BR>Original Statement:<BR><BR>select inst_name from prog where Name="xx" and country="yy"

  2. #2
    Join Date
    Dec 1969

    Default Yes

    e.g.<BR><BR>select inst_name from prog <BR>where (Name=&#039;xx&#039; and country=&#039;yy&#039;) or lukt = &#039;Förskräcklig&#039;<BR><BR>You should not use " for strings in SQL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts