MySQL Forums
Forum List  »  Newbie

new to joins
Posted by: andrew niesen
Date: August 30, 2004 10:03PM

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?

Options: ReplyQuote


Subject
Written By
Posted
new to joins
August 30, 2004 10:03PM
August 31, 2004 02:36AM
August 31, 2004 04:36AM
August 31, 2004 09:36AM
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.