new to joins
i've got the following columns in one table:
table EVENTS:
eventsID (primarykey)
primary_contactID
secondary_contactID
eventcode
and a second table:
table CONTACTS:
contactID
FirstName
LastName
I want to get the last name of both the first and secondary contacts and also the event code.
Can't figure out the Join Syntax. Can you help?
Subject
Written By
Posted
new to joins
August 30, 2004 10:03PM
September 01, 2004 01:46PM
September 01, 2004 10:52PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.