Link to home
Start Free TrialLog in
Avatar of RadhaKrishnaKiJaya
RadhaKrishnaKiJaya

asked on

Join query

Hi Experts,

I have a query like this-

select  PartID,LionPartNo,p.ManufacturerPartNo,PartDescription,LastOrderedCost,PartType,ManuID,VendorID,PartCost  from Parts P LEFT OUTER JOIN VENDORLINECARD V ON P.ManufacturerPartNo=v.ManufacturerPartNo

I also want to join this query with MANUFACTURER table to get the Manufacturer name where the ManuID is same. Also the VENDOR table to get the Vendor name where the VendorID is same. So that in the same query I will get all the information.

Thank you.
ASKER CERTIFIED SOLUTION
Avatar of Evan Cutler
Evan Cutler
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RadhaKrishnaKiJaya
RadhaKrishnaKiJaya

ASKER

Thank you very much. It worked!!