Trying to pull data from two tables in our inventory database. I need to pull the item number, the components that are used to make that item, and the costs of each of the individual components. Using the following query, I get all of the information I need except I can't figure out how to pull the costs of each individual component instead of the cost of the item itself:
SELECT bom50100.itemnmbr, bom50100.itemdesc, bom50100.cmptitnm, iv00101.currcost
FROM bom50100
LEFT OUTER JOIN
iv00101
ON bom50100.itemnmbr = iv00101.itemnmbr
Anyone know how I would get it to pull the individual components costs in the iv00101 table rather than the cost of the item?
SELECT bom50100.itemnmbr, bom50100.itemdesc, bom50100.cmptitnm, iv00101.currcost
FROM bom50100
LEFT OUTER JOIN
iv00101
ON bom50100.itemnmbr = iv00101.itemnmbr
Anyone know how I would get it to pull the individual components costs in the iv00101 table rather than the cost of the item?