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 table1INNER JOIN table2 ON table1.pk=table2.table1Id
INNER JOIN table3 ON table1.pk=table3.table1Id
No comments:
Post a Comment