CODEWITHSUNDEEP
sqlms-accessjoin
Animesh Ghosh
Animesh Ghosh

Reputation: 341

How to join 3 tables by a single sql query?

I have 3 tables.

Table1: Group_Code, Group_Name,companyID;(PK: Group_Code)
Table2: PartyID,GroupID,companyID;(FK: GroupID, PK:PartyID)
Table3: VendorID, companyID;(FK:VendorID)

I want to fetch Group_Name from Table1 for all VendorID of Table3. How can I do this?

here i write a code. But it shows "Syntex error in FROM clause." My database is in ms access.

select Group_Name from Table1 join Table2 on Table1.Group_Code= Table2.GroupID
join Table3 on Table2.PartyID=Table3.VendorID

Upvotes: 0

Views: 164

Answers (5)

Punching Worms
Punching Worms

Reputation: 113

select Group_Name from Table1 
join Table2 on Table1.Group_Code = Table2.GroupID 
join Table3 on Table2.PartyID = Table3.VendorID

Upvotes: 1

kasim
kasim

Reputation: 356

use this code for question,

Select Table1.Group_Name  from ((Table1
left join Table2 on Table1.Group_Code=Table2.GroupID)
left join Table3 on Table2.PartyID=Table3.VendorID)

Upvotes: 0

vhadalgi
vhadalgi

Reputation: 7189

try this !!! 

SELECT table1.group_name FROM (table1
     INNER JOIN ON table1.group_code=table2.groupid)
        INNER JOIN table3 ON table2.partyid=table3.vendorid

    GROUP BY    table1.group_name

Upvotes: 1

Jeet
Jeet

Reputation: 1587

You Can do this :

select Table1.Group_Name, Table3.VendorID from Table1 join Table2 on Table1.Group_Code= Table2.GroupID join Table3 on Table2.PartyID =Table3.VendorID

If you are data has been stored in proper relationship. the query should get you going. :)

Upvotes: 0

vhadalgi
vhadalgi

Reputation: 7189

SELECT table1.group_name FROM table1 join table2 
                   ON table1.group_code=table2.groupid
                       join table3 ON table2.partyid=table3.vendorid

error becoz you didnt take the group name DB instance ?

Upvotes: 0

Related Questions