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.