JOIN Query question

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top