Nested SELECT problem

[delbronx]

I'm working on an update page, and need to detect all records from table1 that don have a reference in table 2 i've tryed this but dont work

SELECT Empresa.Id_Empresa
FROM Empresa
WHERE Empresa.Id_Empresa
NOT IN
SELECT Invitacion.Id_Empresa
FROM Empresa
INNER JOIN Invitacion ON (Empresa.Id_Empresa = Invitacion.Id_Empresa)
WHERE
(
(Invitacion.Id_Evento = 1)
)

SELECT Id_Empresa
FROM Empresa
WHERE
(
(Id_Empresa NOT IN (SELECT Id_Empresa FROM Invitacion WHERE (Id_Evento=1)))
)

can anyone help me, please

[Anon]

If you are using mysql, the problem is that mysql does not support subselects in the current release.

Try using a LEFT JOIN instead (untested code):

SELECT Empresa.Id_Empresa
FROM Empresa
left join Invitacion
on Empresa.Id_Empresa = Invitacion.Id_Empresa
WHERE Invitacion.Id_Evento is null