Header menu

_________________________________________________________________________________

Monday, 3 February 2014

Inner join between more than two tables


Inner Join between more than two tables

To explain this lets take an example.
We have three table table1,table2,table3 .
table1 has primary key pk on which we want to take join of three table.

Query :  

SELECT * FROM table1
INNER JOIN table2 ON table1.pk=table2.table1Id
INNER JOIN table3 ON table1.pk=table3.table1Id