MySQL Forums
Forum List  »  Newbie

query on joining two tables.
Posted by: salim slime
Date: February 26, 2009 12:21AM

I have a database having two tables.

First table contains a column for abbreviations and a column showing the full names (100 rows).

The second table has three columns; two having abbreviations and one containing the row_id (total of 50 rows).

The following query gives only the full name of person and initails of friend

select f.`row_id`, a.`full_name`, f.`friend` from friendandfamily f left outer join allNames a on f.`person`=a.abbreviation;

how do i join the tables so that am able to view all row_id (50 rows) in table 2 with the corresponding full names in the rows 2 and 3.

Options: ReplyQuote

Written By
query on joining two tables.
February 26, 2009 12:21AM

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.