MySQL Forums
Forum List  »  Newbie

iso FULL OUTER JOIN
Posted by: Joe Cotton
Date: April 14, 2005 01:44PM

I need to do a full outer join, but have not seen this available in the fine manual. Is this type of join available?

The task is to list everyone that has departed the company in a certain date range. Sometimes a record is entered on table A, sometimes on table B, sometimes on both.

SELECT a.NAME, b.NAME FROM TABLEA A FULL OUTER JOIN TABLEB B ON A.SSN = B.SSN WHERE A.DEPART_DATE BETWEEN @BEGIN AND @END or
B.DEPART_DATE BETWEEN @BEGIN AND @END

I saw one other inquiry from another newbie on this discussion list, but no one answered.

Options: ReplyQuote


Subject
Written By
Posted
iso FULL OUTER JOIN
April 14, 2005 01:44PM
April 15, 2005 02:35AM


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.