asp.net with c#

http://www.w3resource.com/sql/joins/using-a-where-cluase-to-join-three-or-more-tables-based-on-a-parent-child-relationship.php






Try the above link well explained with example

Hello @shivshankar  you can follow this pattern for join on tables

select * from My_Table
left outer join Table2
on 
My_Table.IId=Table2.IId
where My_Table.IId>10

for more explanation you can see below links:

http://www.w3schools.com/sql/sql_join.asp

http://www.codeproject.com/Articles/435694/Understanding-Table-Joins-using-SQL

Hi,

Please check following links:

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/
https://technet.microsoft.com/en-in/library/ms191517(v=sql.105).aspx

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