You are here
Home > Posts tagged "full join"

SQL JOIN (OUTER JOIN)

SQL JOIN Outer Join: Outer join returns all rows from one table and matching rows from second table. There are three types of Outer join: 1) Left Outer Join 2) Right Outer Join 3) Full Outer Join Syntax: select column_name(s) from table_name1 left | right | full [outer] join table_name2 on table_name1. column_name= table_name2. column_name Left Outer

Top