Hi all,

Noeld, you approach aren’t correct. If you have one item with same number of components, and only one is equals it counts it. One example: if you change ITEM_ID...

Not really...

An example (for simplicity I ignore the TYPE column): the item with ID 7 (in ITEM_COMP table) should be composed by component AAA and BBB. In my products table,...

Ok! My example isn't very happy!!

Changing the tables:

PROD_ID    COMPONENT   TYPE

--------- ----------- -----

1         AAA         X

1         BBB         Y

2         AAA         X

3         BBB         Y

4         AAA         Y

5         AAA         X

5         BBB         Y

6         AAA         X

6         BBB         Y

7         AAA         X

September 14, 2005 at 7:50 am