RadhaKrishnaKiJaya
asked on
Join query
Hi Experts,
I have a query like this-
select PartID,LionPartNo,p.Manufa cturerPart No,PartDes cription,L astOrdered Cost,PartT ype,ManuID ,VendorID, PartCost from Parts P LEFT OUTER JOIN VENDORLINECARD V ON P.ManufacturerPartNo=v.Man ufacturerP artNo
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.
I have a query like this-
select PartID,LionPartNo,p.Manufa
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER