Your current statement, with the OR, says to select a record if its name
is not FIND_ME or if its name is not OPEN. That will be all of them. I
expect you want all of them except the ones named FIND_ME and OPEN. So,
you want AND instead of OR, because logically, "NOT (this OR that)" =
"NOT t
Jess,
You should use an AND (&&) instead of the OR. You result is everything,
correct? When the query is doing the machinename != 'FIND_ME', the
record(s) with machinename = 'OPEN' are being returned. Likewise, when the
machinename != 'OPEN' is being performed, the records(s) with machinename =
Am Friday 09 January 2004 17:57 schrieb Stefan Kuhn:
> Am Friday 09 January 2004 17:22 schrieb Hunter, Jess:
> > Could someone have a look at this syntax and give me some guidance what I
> > may be overlooking?
> >
> > SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename !=
> > 'O
Am Friday 09 January 2004 17:22 schrieb Hunter, Jess:
> Could someone have a look at this syntax and give me some guidance what I
> may be overlooking?
>
> SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename !=
> 'OPEN'
Some other thing: Instead of saying "where x!=a and x!=b" y
Am Friday 09 January 2004 17:22 schrieb Hunter, Jess:
> Could someone have a look at this syntax and give me some guidance what I
> may be overlooking?
>
> SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename !=
> 'OPEN'
A query like "where x=a or s=b" will always return all valu
