Incorrect syntax near ',' - What's wrong!? 1

[xscape]

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!

 

[JayKusch]

SELECT * FROM Newsletter WHERE VisitorCountry IN ('DZ','AS','AD') AND VisitorPhoneType IN ('Alcatel BE3','Alcatel BE4','Alcatel BF3')



Thanks

J. Kusch

 

[xscape]

Looks like a good way of doing it - thanks! I sorted it about 10 seconds after posting using the syntax:

SELECT * FROM Newsletter WHERE (VisitorCountry='DZ' OR VisitorCountry='AS' OR VisitorCountry='AD') AND ( VisitorPhoneType='Alcatel BE3' OR VisitorPhoneType='Alcatel BE4' OR VisitorPhoneType='Alcatel BF3');

Bit more complicated than your option so I might use that instead!

Thanks for your input!