Hi,
I've been going over and over this but can't see the syntax error. Here's the query:
SELECT * FROM Newsletter WHERE VisitorCountry='DZ','AS','AD' AND VisitorPhoneType='Alcatel BE3','Alcatel BE4','Alcatel BF3';
The error I keep getting is: Incorrect syntax near ','
Any ideas what is wrong with this query? It seems to work fine if I only use one value for VisitorPhoneType but goes wrong when I use more than one. I can use as many VisitorCountry values as I like wihtout problems though.#
Any ideas?
Thanks a lot - it's driving me mad!
I've been going over and over this but can't see the syntax error. Here's the query:
SELECT * FROM Newsletter WHERE VisitorCountry='DZ','AS','AD' AND VisitorPhoneType='Alcatel BE3','Alcatel BE4','Alcatel BF3';
The error I keep getting is: Incorrect syntax near ','
Any ideas what is wrong with this query? It seems to work fine if I only use one value for VisitorPhoneType but goes wrong when I use more than one. I can use as many VisitorCountry values as I like wihtout problems though.#
Any ideas?
Thanks a lot - it's driving me mad!