Multiple joins 1

[litton1]

Hi all, having problems with my joins again .
I cannot fathom where the brackets go when I have three joins, any help much appreciated.

 SELECT s.S_SupplierID AS SupplierID, blah, blah
 FROM Suppliers s
     INNER JOIN SupplierProducts sp ON SP_SupplierID = S_SupplierID
    INNER JOIN Products p ON p.P_ItemID = sp.SP_ItemID
    INNER JOIN Items i on p.P_ItemID = i.I_ItemID

Thx T

Age is a consequence of experience

 

[PHV]

SELECT s.S_SupplierID AS SupplierID, blah, blah
FROM ((Suppliers s
INNER JOIN SupplierProducts sp ON SP_SupplierID = S_SupplierID)
INNER JOIN Products p ON p.P_ItemID = sp.SP_ItemID)
INNER JOIN Items i on p.P_ItemID = i.I_ItemID

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[litton1]

Thanks. i can see how this works now.

Age is a consequence of experience

 

[litton1]

This seems not to work?

 SELECT s.S_SupplierID AS SupplierID
  FROM (( Suppliers s  
  INNER JOIN SupplierProducts sp ON SP_SupplierID = S_SupplierID )  
  INNER JOIN Products p ON p.P_ItemID = sp.SP_ItemID)  
  INNER JOIN Items i on p.P_ItemID = i.I_ItemID

Any ides?

Age is a consequence of experience

 

[PHV]

I'd try this:
INNER JOIN SupplierProducts sp ON [!]sp.[/!]SP_SupplierID = [!]s.[/!]S_SupplierID)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[litton1]

hmm. I will give myself a slap for that!!

have another star for your trouble.

Age is a consequence of experience