hemant kumar
What is outer join?Explain with examples.
1 Answer(s)      4 years and 7 months ago
Posted in : SQL

What is outer join?Explain with examples.

Advertisement
View Answers

November 18, 2010 at 5:44 PM


Hi,

The SQL OUTER JOIN clause is a variation of the SQL JOIN clause enables a SELECT statement to access more than one table. The JOIN clause controls how tables are linked. It is a qualifier of the SQL FROM clause.

SQL OUTER JOIN Syntax

SELECT <column_name1>, <column_name2> <aggregate_function>
FROM <table_name>
LEFT OUTER JOIN <table_name> ON <join_conditions>

thanks.