I am trying to use the WHERE clause along with AND NOT. My problem is that I have 10 different values of the same column that I do not want to select. An example of my problem is as follows:
select * from myTable WHERE state NOT 'FL' AND state NOT 'TX' AND state NOT
'WY' AND state NOT 'MI' AND state NOT 'CA' AND state NOT 'IL' ... and so on
I come up with a syntax error near 'FL'
Is there an easier way to do this since they are all coming from the same attribute?
Aucun commentaire:
Enregistrer un commentaire