Database Concept

Inner Joins and left Joins in SQL with Examples

Written by Techringe

List of Best Database Programming Concept interviews Questions with Examples. Top MSSQL  concepts with examples.Difference Between Inner Joins Vs Outer Joins.

Inner Joins 

Returns records that have matching values in both tables

Query Example

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;




Left Joins

Returns all records from the left table, and the matched records from the right table

Query Example

SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;

 

About the author

Techringe

techringe.com is Platform which offers Free download latest project source code in java, android, php, html, c# .net, c/c++, iphone, vb, python, jsp, asp .net, all programming lanugage.

Leave a Comment