Link to home
Start Free TrialLog in
Avatar of dowhatyoudo22
dowhatyoudo22

asked on

How to create a sql query that pulls data from multiple tables

Running SQL Server 2012. Need assistance creating a query that pulls data from multiple tables. I have the key/column I want to use to retrieve data from each of the tables juts need assistance with creating the syntax for the query I can use to do so.
ASKER CERTIFIED SOLUTION
Avatar of Dan Craciun
Dan Craciun
Flag of Romania image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you want to retrieve data from multiple tables then you can use inner join method of Sql.This type of join method is used to contain information from a combination of two or more tables.With the help of inner join condition you can determine which records are paired together and it is specified in the WHERE clause.For reference you can visit:

databases.about.com/od/careers/l/aajoins1.htm
It would be helpful if you could provide the definition of the three tables, along with details of what you want your query to return.
dowhatyoudo22, do you still need help with this question?