MySql question

[cash_hr]

I have two tables.
One with guest data, and second with guest emails.
In first I have id cell, and in second guest_id that is =id in first table.

how can I select guests that hasen't got any email?!?
😕

P.S. I want to select guests where "id in(some list of ids)"

Thanks in advance

cash

[Wien]

Guest that hasn't got any emails :

SELECT Guest.IdGuest FROM Guest LEFT JOIN Email ON Guest.IdGuest = Email.IdGuest AND Email.IdGuest IS NULL

[cash_hr]

Tnx

[cash_hr]

I've tried with

SELECT * FROM nl_guest LEFT JOIN nl_email ON nl_guest.id in(3110,3092) AND nl_guest.id=nl_email.guest_id IS NULL ORDER BY name

but is doesn't work.

Any help?!?

[tomhath]

SELECT * FROM nl_guest
LEFT JOIN nl_email
ON nl_guest.id=nl_email.guest_id
WHERE nl_guest.id in (3110,3092)
AND nl_email.guest_id IS NULL
ORDER BY name

[cash_hr]

I was tried this, but query returns nothing.

In table nl_email there is row with guest_id 3110, but row with guest_id 3092 does not exists.

So, with this query, I have to get data from guest with id 3092.....

But i can't.. 🙁

Any more suggestions, please.

Thank you very much

[cash_hr]

Hi!

I've tried without
"nl_email.guest_id in(3110,3092) AND"
statment, and thats work.

Does I use in() statment wrong?

[cash_hr]

sorry, I was blind.

I was type "nl_email.guest_id in (3110,3092) ",
not
"nl_guest.id in (3110,3092) "

Thanks