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



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

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


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