Left Join 1

[litton1]

Can anybody see what is wrong with this simple query? The error seems to be in the Left Join

SELECT  p.[P_ItemID] AS ProductID,  i.[Name],  PQ.[QuantityOnStock]
FROM  [Products] p  
 INNER JOIN [Items] i ON i.[I_ItemID] = p.[P_ItemID]  
  LEFT JOIN ProductQuantitys PQ ON PQ.[PQ_ItemID] = p.[P_ItemID]

Thx L

Age is a consequence of experience

 

[r937]

access requires parentheses when there is more than one join in a query

SELECT p.P_ItemID AS ProductID
     , i.Name
     , PQ.QuantityOnStock
  FROM [b][red]([/red][/b]
       Products AS p   
INNER 
  JOIN Items AS i 
    ON i.I_ItemID = p.P_ItemID   
       [b][red])[/red][/b] 
LEFT OUTER
  JOIN ProductQuantitys AS PQ 
    ON PQ.PQ_ItemID = p.P_ItemID

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[litton1]

Thanks that works now. Have a star.

Age is a consequence of experience