Query assistance

Forum|Forum|4 years ago
February 20, 2021
2 replies
260 views

I took this from Access and have used IS NOT. I took everything out except for "Wal-mart", Changed to Wal-Mart and 'Wal-mart'. Nothing works unless I take the entire Where clause out. Any help would be appreciated.

WHERE ShipToName NOT ("Wal-Mart" OR "GCC Belvidere IL") AND FOB ="delivered" AND ShipToID Not ("MAN-002" OR "OXN-001" OR "WAT-001")))

This topic has been closed for replies.

J

John123

Participating Frequently

As Charlie says the databsae you are using is important to know but your query in SQL that is applicable to most DB's could use lists and look something like

WHERE ShipToName NOT IN ('Wal-Mart', 'GCC Belvidere IL') AND FOB = 'delivered' AND ShipToID NOT IN ('MAN-002', 'OXN-001', 'WAT-001')

The parentheses is your where clause do not match up, you have extra on the end, so is there more than you posted here?