Shweta Lodha12y agoPosted Feb 6, 2014, 3:16 PMHey Vivek,A nice tutorial is given here:http://technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx0
Hemant Srivastava12y agoPosted Feb 6, 2014, 2:43 PMYou may refer to :http://hemant-srivastava.blogspot.com/2012/09/quick-review-of-sql-joins.html0
Anurag Sarkar12y agoPosted Feb 6, 2014, 12:53 PMHere is the Inner JoinSELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDateFROM OrdersINNER JOIN CustomersON Orders.CustomerID=Customers.CustomerID;Sample TableOrderIDCustomerNameOrderDate10308Ana Trujillo Emparedados y helados9/18/199610365Antonio Moreno Taquería11/27/199610383Around the Horn12/16/199610355Around the Horn11/15/199610278Berglunds snabbköp8/12/1996Thanks Please mention what do you want to know more about Joins.0
Shweta LodhaPosted Feb 6, 2014, 3:16 PM
A nice tutorial is given here:
http://technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx
Hemant SrivastavaPosted Feb 6, 2014, 2:43 PM
http://hemant-srivastava.blogspot.com/2012/09/quick-review-of-sql-joins.html
Anurag SarkarPosted Feb 6, 2014, 12:53 PM
SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers
ON Orders.CustomerID=Customers.CustomerID;
Sample Table
Thanks Please mention what do you want to know more about Joins.