J
James Taylor
Hi All,
I have a JOIN query that I cannot seem to finish.
I have a Bill of Material Table and an Inventory Table.
I need to end up pulling a Bill of Material for a given machine, and
alongside the individual part numbers, I need the retail pricing, which is a
field available in the Inventory Table.
This is what I have so far
SELECT*
FROM DBA_INVENTORY_07072003, BOM_QUERY
WHERE BOM_QUERY.BKBM_COMPONENT=DBA_INVENTORY_07072003.BKIC_PROD_CODE ;
I need to be able to pull for a given BKIC_PROD_CODE in BOM_QUERY TABLE
Can anyone lead me down the correct road?
Thanks!
I have a JOIN query that I cannot seem to finish.
I have a Bill of Material Table and an Inventory Table.
I need to end up pulling a Bill of Material for a given machine, and
alongside the individual part numbers, I need the retail pricing, which is a
field available in the Inventory Table.
This is what I have so far
SELECT*
FROM DBA_INVENTORY_07072003, BOM_QUERY
WHERE BOM_QUERY.BKBM_COMPONENT=DBA_INVENTORY_07072003.BKIC_PROD_CODE ;
I need to be able to pull for a given BKIC_PROD_CODE in BOM_QUERY TABLE
Can anyone lead me down the correct road?
Thanks!