Re: new to joins

[Ramalingam Chelliah]

Hi,
Check if this helps you...
(Taking Harsha Chaithanya K's assumption of foreign keys)

SELECT X.LastName,Y.LastName,Z.eventcode
FROM
EVENTS as Z
LEFT OUTER JOIN
CONTACTS as X
ON Z.primary_contactID=X.contactID
LEFT OUTER JOIN
CONTACTS as Y
ON Z.secondary_contactID=Y.contactID ;

Regards,
Ram.

P.S:
If primary and secondary contacts are mandatory then use simple "inner join" ( comma separated table list)


We Learn the Most When we have to Invent