table joining in sql server

Question

with example

Shweta Lodha · Answer

Hey Vivek A nice tutorial is given here: http://technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx

Hemant Srivastava · Answer

You may refer to : http://hemant-srivastava.blogspot.com/2012/09/quick-review-of-sql-joins.html

Anurag Sarkar · Answer

Here is the Inner Join SELECT Orders.OrderID Customers.CustomerName Orders.OrderDate FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID; Sample Table OrderID CustomerName OrderDate 10308 Ana Trujillo Emparedados y helados 9/18/1996 10365 Antonio Moreno Taquería 11/27/1996 10383 Around the Horn 12/16/1996 10355 Around the Horn 11/15/1996 10278 Berglunds snabbköp 8/12/1996 Thanks Please mention what do you want to know more about Joins.