query on joining two tables.

[salim slime]

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.