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

1.3k

with example

Answers (3)

Next Recommended Forum

How to create JobSchedular in sqlserver2008 R1?

visual studion connection sql server error

Forum Statistics

Please welcome our newest member Vivieanna Hale.
3,094,064 users have contributed to 147,395 threads and 483,638
In the past 24 hours, we have 3 new threads, 9 new posts, and 93 new users.
In last week, the most popular thread is 'Explain the MVC application life cycle in DotNet'.

Upcoming Events

View all

Next-Gen Apps with AI and Power Platform
Software Architecture Conference - 2025
Automated Sales Quote Approval Workflow for Faster Deal Closure: Automate Your Business Processes - Ep.9