Learn SQL Database Programming

Learning RIGHT OUTER JOIN syntax

To RIGHT OUTER JOIN two tables, use the following syntax:

SELECT column(s)FROM table1RIGHT OUTER JOIN table2ON table1.column = table2.columnWHERE conditions ORDER BY column(s); 

The previous syntax shows you how to join two tables together with a RIGHT OUTER join. You join a column in table1 that matches a column in table2. The WHERE and ORDER BY clauses are optional. They are there to show you that the RIGHT OUTER JOIN syntax goes between the FROM and WHERE clauses.

The following example will help you to understand how to use the RIGHT OUTER JOIN:

SELECT p.playerid, asf.yearid, gameid, startingpos FROM lahmansbaseballdb.allstarfull asfRIGHT OUTER JOIN lahmansbaseballdb.people p ON p.playerid = asf.playerid; ...