RE: [PHP-DB] Simple SQL Query??
| From: | Adam Douglas | Date: | Mon, 12 May 2003 17:13:34 +0000 |
| Subject: | RE: [PHP-DB] Simple SQL Query?? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27674@lists.php.net to get a copy of this message | ||
Geez, you know I hate it when you realize something after the fact of
posting a message. The query is working perfectly fine using the != or <>.
The problem is I suppose how the query itself is written. See here's my
situation. I need a query that shows me all the web accounts (people) except
those that are in a specific security group.
I have two tables one that stores all the web accounts (tblWebAccounts) and
related information. The other table (tblWebAccountGroup) that stores what
web account is associated to what WebAccountGroup (web security group).
Any ideas?
strange, so with != doesn't work?
did you try <> instead of !=
what also could be the problem:
when using <> or != and having more AND statements... it could be usefull to
use () around some statements, but because I can't test it, i can'tr give
the good advise....