Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What is outer join?Explain with examples.

Have Programming Question? Ask it here!
 
 
 


hemant kumar
What is outer join?Explain with examples.
1 Answer(s)      3 years and 8 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.



Related Tutorials/Questions & Answers:
Advertisements
Advertisements
 

 

 

DMCA.com