innerjoin between 3 table columns

Question

innerjoin between 3 table columns

anithareddyg1

Old Hand

Points: 354
More actions
August 25, 2008 at 12:42 pm

#191482

Hai,
i want to know innerjoin between 3 tables ata a time.
plz helpme.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184393 More actions · Answer 1

Could you give us a little more information? Table names, column names? Do you mean joining 3 tables or using 3 columns to join 2 tables?

Here's an example of a 3 table join:

[font="Courier New"]/* tables

Orders(OrderID Primary Key, CustomerID, OrderDate)

OrderDetails(OrderDetailID Primary Key, OrderID, ProductId, OrderQty)

Products(ProductID Primary Key, ProductName, ProductDescription)

*/

SELECT

O.OrderDate,

D.OrderQty,

P.ProductName

FROM

dbo.Orders O INNER JOIN

dbo.OrderDetails D ON

O.OrderID = D.OrderID INNER JOIN

dbo.Products P ON

D.ProductID = P.ProductID[/font]

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

anithareddyg1 Old Hand Points: 354 More actions · Answer 2

Thank you,

joining different columns in 3 tables using innerjoin.

once again thankyou.

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 3

anithareddyg1 (8/25/2008)
Thank you,
joining different columns in 3 tables using innerjoin.
once again thankyou.

Jack just gave you an example for a three-table join - is that what you need? There are no specifics, no issue described, not even a question asked. What do you need to know? What do the tables look like?

In other words - help us help you by asking the question(s) you have about this setup.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

anithareddyg1 Old Hand Points: 354 More actions · Answer 4

Actually im getting the answer for ur first reply.

because im not give u full description about that.

sorry for inconvinence

thank you

asifusman1998 SSC Enthusiast Points: 124 More actions · Answer 5

Thank you very much......... Really this article, helps me alot.

asifusman1998 SSC Enthusiast Points: 124 More actions · Answer 6

Jack Corbat you are great....... you solve on of my very big problem....

supp.dehradun SSC Rookie Points: 45 More actions · Answer 7

supp.dehradun

SSC Rookie

Points: 45

May 5, 2015 at 2:20 am

#1795527

thank you