>This is probably a pretty simple question, but I can't figure out a way to do this with one select statement. I want to query a table that contains information on 32 companies. I need to query infomation on 30 of those companies. I've tried all of the commands below with no avail. > >Select from where field1 <> 'A' or field1 <> 'B' > >Select from where field1 <> 'A' and field1 <> 'B' > >Select from where (field1 <> 'A' or field1 <> 'B') > >Select from where (field1 <> 'A' and field1 <> 'B') > >All of these picked up the info on all of the companies. I've run into this problem before and have just done the following (which I can do again). > >Select from >delete all for field1 = 'A' or field1 = 'B' > >I was just wondering if there was a way to get the results I want without doing the delete command. >
