|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
SQL Where Statement -- HELP
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"<br><br>Thank you...
|
|
#2
|
|||
|
|||
|
Yes, just add it onto the end....
|
|
#3
|
|||
|
|||
|
Instead of putting " " u should put just ' ' <br><br>eg:<br><br>select inst_name from prog where Name= 'xx' and country='yy'
|
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > SQL Where Statement -- HELP |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|