How to join 3 tables by a single sql query?

Question

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

Answer 1

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

Answer 2

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

Answer 3

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 ?

Answer 4

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. :)

Answer 5

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)