joins in sqlserver

Question

Hi  can anyone tell me how to join 4 tables with example and what are the conditions to check. Thanks.

Anil Kumar · Answer

Why you want to join tables? This will become your condition to apply for joining tables. There are Left Right Inner  Cross joins and which one to apply/use? Again your requirement will put you to choose right join. Just look into right side recommended article links for this. Or go through - http://www.c-sharpcorner.com/UploadFile/raj1979/joins-in-sql-server-2005/ Introduction to Joins in Sql Server