SQL Statement to extract more than one line?

[loner]

I want to extract many e-mails from this Access database, but I get an error or it doesn't extract properly every time I run the script.

This one runs fine:
SELECT panalists.EMAIL
FROM panalists
WHERE (((panalists.EMAIL)="02hsegurity@prtc.net&quot);

But this one fails:
SELECT panalists.EMAIL
FROM panalists
WHERE (((panalists.EMAIL)="02sandhsegurity@prtc.net" & " lt705@hotmail.com&quot);

Or even:
SELECT panalists.EMAIL
FROM panalists
WHERE (((panalists.EMAIL)="02sandhsegurity@prtc.net" , " lt705@hotmail.com&quot);

I just want to extract both e-mails from database, can anyone help?

Thanks,
C

 

[DrJavaJoe]

WHERE (((panalists.EMAIL)="02sandhsegurity@prtc.net or lt705@hotmail.com&quot);

 

[loner]

That does work, but I'm looking to extract both e-mails at one time, not one or the other.

 

[DrJavaJoe]

This will extract both emails, what the statement is saying is select all panalists.EMAIL From the table Panelists Where the email is either 02sandhsegurity@prtc.net or lt705@hotmail.com"

 

[loner]

Yeah, that does work, but for some reason, it's giving me a list of 1500 emails.

Here's the query:
SELECT panalists.EMAIL
FROM panalists
WHERE (((panalists.EMAIL)="02sandhsegurity@prtc.net" or "lt705@hotmail.com&quot);

Any idea?

 

[DrJavaJoe]

Try this
SELECT panalists.IDField, panalists.EMAIL
FROM panalists
WHERE panalists.EMAIL in ("02sandhsegurity@prtc.net", "lt705@hotmail.com"

 

[DrJavaJoe]

Don't know what I was thinking to use the OR it should be like:
WHERE panalists.EMAIL="02sandhsegurity@prtc.net" or panalists.EMAIL="lt705@hotmail.com";
So for what you are trying to do use the IN statement.

 

[loner]

Thank you, DrJavaJoe, that worked

 

[DrJavaJoe]

Glad that I could help.