asp.net with c#

Question

how to make it one or more table join in sql server 2008

Dhanasekar · Answer

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

Pankaj Kumar Choudhary · Answer

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

Prasham Sabadra · Answer

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

Khargesh Rajput · Answer

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