SQL Query Question (<>)

[lexiwynona]

Hi All:
I am new to this website. I just have a simple SQL question. In my query I
want to retrieve all records except the "com" and "non" records in a status
field. When I use the <>"com" I get all the data I need, however, I also get
one lone "non" record. How do I combine the "<>("com" Or "non")" SQL query?
Thanks in advance,
Lexi

 

[John Vinson]

Hi All:
I am new to this website. I just have a simple SQL question. In my query I
want to retrieve all records except the "com" and "non" records in a status
field. When I use the <>"com" I get all the data I need, however, I also get
one lone "non" record. How do I combine the "<>("com" Or "non")" SQL query?
Thanks in advance,
Lexi

NOT IN ("com", "non")

or

<> "com" AND <> "non"


John W. Vinson[MVP]