B.O.M. problem

[emax6]

I have a table that give me the detail for each product can use. For ex:
Tbl1.ItemNb, Tbl1.Color, etc,,

I have a table that gives me the list of all components for a specific product:
Tbl2.Item1, Tbl2.Component1
Tbl2.Item1, Tbl2.Component2
Tbl2.Item1, Tbl2.Component3
Etc…

Since I need to have the detail for let’s say Tbl2.Component1, I need to link Tbl2.Component1 to Tbl1.ItemNb.

Is it possible to create a SQL syquery that will select Tbl1.ItemNb with the list of all component listed in Tbl2, and for each component from Tbl2, the detail for each component that I can retrieve from the Tbl1.
Hope the explanation is clear.

 

[PHV]

Have a look here:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886