Learn SQL Database Programming

Using FULL OUTER JOIN

To join a table with FULL OUTER JOIN, execute the following SQL code:

USE lahmansbaseballdbSELECT p.playerid, asf.yearid, gameid, startingpos FROM allstarfull asfFULL OUTER JOIN people p ON p.playerid = asf.playerid; 

You can see in the preceding query that you are joining the allstarfull table to the people table with a FULL OUTER JOIN. This query will return all rows from the people table and all rows from the allstarfull table. Where there isn't a matching row in either table, you will see NULL values, as illustrated in the following screenshot:

As you can see in the previous screenshot, the results show NULL values ...