>Hi,
>
>I have 2 tables:
>
>Employee table 2 fields:
>
>EmpID EmpName
>11111 JoeBlo
>22222 JackWhite
>33333 JohnBlack
>44444 MaryGreen
>55555 MeeLee
>66666 SeeLoo
>77777 TeeNoo
>
>
>Idcard table 2 fields:
>
>EmpID ExpireDate
>11111 01/31/2013
>22222 02/28/2013
>33333 03/31/2013
>44444 04/30/2013
>55555 12/31/2012
>
>Find all employees either without an IDcard or with one that has expired ?
>
>SELECT * FROM Employee WHERE EmpID not IN(SELECT IDCard.EmpID FROM IdCard);
>
>How do I do to have with one that has expired like empID = 55555
>
>Thank you,
SELECT Employee.*;
FROM Employee;
LEFT JOIN IdCard ON Employee.EmpID = IdCard.EmpID AND IdCard.ExpireDate >= DATE();
WHERE IdCard.EmpID IS NULL
SELECT Employee.*;
FROM Employee;
INNER JOIN IdCard ON Employee.EmpID = IdCard.EmpID;
WHERE IdCard.ExpireDate < DATE();
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.