help with sql statement
| From: | Adam | Date: | Mon, 12 Jul 2010 15:24:35 +0000 |
| Subject: | help with sql statement | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-306832@lists.php.net to get a copy of this message | ||
I was google searching, and the only SQL mailing list I found is currently giving a 503 error, so I hope you don't mind me asking my SQL question here, since there are a lot of SQL gurus here. I am having a syntax problem:
Instead of doing a query like this::
select SMS_R_SYSTEM.Name from SMS_R_System where (SMS_R_System.SystemOUName = "example.com/COMPUTERS/MAIN CAMPUS/ABC") or (SMS_R_System.SystemOUName = "example.com/COMPUTERS/MAIN CAMPUS/XYZ")
I'd like to shorten it in the where clause to:
select SMS_R_SYSTEM.Name from SMS_R_System where (SMS_R_System.SystemOUName = "example.com/COMPUTERS/MAIN CAMPUS/ABC", "example.com/COMPUTERS/MAIN CAMPUS/XYZ")
But I'm getting a syntax error. Any idea why my SQL syntax isn't valid?