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

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

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.

Answers

table joining in sql server

vivek upadhyay

11y

833

1 COM Interop

with example

table joining in sql server

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)