SQL RIGHT JOIN .

SQL using RIGHT JOIN.

• RIGHT JOIN - Return all rows from the right table, even if there are no matches in the left table of two tables joined.

  Pictorial representation :

• RIGHT JOIN and RIGHT OUTER JOIN are the same.
• A skeleton version of RIGHT JOIN syntax is this:

  SELECT select_list
  FROM table_1 RIGHT [OUTER] JOIN table_2
  ON [table_1.]column  join_operator  [table_2.]column
  [WHERE search_conditions ]
  [ORDER BY column1, column2, ... ]

  Example using RIGHT JOIN between the tables:

  SQL server, MySQL, Oracle, PostgreSQL :

  Select a.US_STATE_CD "Addresses code", ADDR_LINE "Address",
          CITY, u.US_STATE_CD "State code", US_STATE_NM 
   from ADDRESSES a
   RIGHT OUTER JOIN US_STATES u
   ON a.US_STATE_CD=u.US_STATE_CD
  WHERE US_STATE_NM LIKE 'A%'
  ORDER BY u.US_STATE_CD;

  The result should be:

  Addresses code	Address	city	State code	us_state_nm
  			AK	Alaska
  			AL	Alabama
  AR	3009 Table Rock Road Biglerville	Alleene	AR	Arkansas
  AR	3009 Table Rock Road Biglerville	Alleene	AR	Arkansas
  			AZ	Arizona