OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
SELECT Query assistance please

From: Luc Foisy (Luc.Foisytechnical-magic.com)
Date: Thu Nov 13 2003 - 13:01:24 CST

I have two tables EVENT and PROJECTCODE

EVENT.ID
EVENT.ID_PROJECTCODE

PROJECTCODE.ID
PROJECTCODE.Name

EVENT PROJECTCODE
ID = 1 ID_PROJECTCODE = 0 ID = 1
ID = 2 ID_PROJECTCODE = 0 ID = 2
ID = 3 ID_PROJECTCODE = 1 ID = 3
ID = 4 ID_PROJECTCODE = 4 ID = 4

SELECT PROJECTCODE.ID AS 'ID', PROJECTCODE.Name AS 'Reference' FROM PROJECTCODE

Not quite sure on the join or where claus here, I tried 3 or 4 different ways and can't seem to get what I want.
What I want out of the results is PROJECTCODE.ID = 2 and 3, that being all records in PROJECTCODE that do not appear in EVENT

Luc

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql