How to extract details of Manufacturers tab attributes for a Part via SQL?

Answered

Hi,

I’m writing SQL to extract the details of Manufactures tab attributes for a PART object. the name of the Mfr and Part Num are coming from different tables. However, I couldn’t find the link between the Part number and Mfr Name. Any guidance to resolve this will be helpful.

Thanks,

Manoj.

Add Comment
1 Answer(s)
Best answer

Manoj,

Try this…

SELECT MP.PART_NUMBER, M.NAME
FROM AGILE.MANUFACTURERS M
INNER JOIN AGILE.MANU_PARTS MP ON M.ID = MP.MANU_ID
INNER JOIN AGILE.MANU_BY MB ON MP.ID = MB.MANU_PART
INNER JOIN AGILE.ITEM I ON MB.AGILE_PART = I.ID
WHERE MB.PREFER_STATUS = 1
AND MB.CHANGE_OUT = 0
AND I.ITEM_NUMBER = :ITEMNUMBER

Agile Professional Answered on April 1, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.