Need some help using three inner joins

  • Thread starter Thread starter dmeckley
  • Start date Start date
D

dmeckley

I presently have a query similar to:

SELECT P.vendId, V.[name] as vendorName, P.manufId,M.[name] as
manufacturerName, ... FROM (Part P INNER JOIN Vendor V ON P.vendId =
V.vendorId)INNER JOIN Vendor M ON P.manufId = M.vendorId

I need to get a name from an equip table by an id number in the P table.
I'm not sure how to correctly add the third inner join.
 
Try something along the lines of
FROM ((Part P INNER JOIN Equip E on P.equipId = E.equipId)
INNER JOIN Vendor V ON P.vendId =
V.vendorId)INNER JOIN Vendor M ON P.manufId = M.vendorId

Hope This Helps
Gerald Stanley MCSD
 
Back
Top