Subject CTE Question
Author Olaf Kluge

in advance, many thanks!

I would like to combine all properties like this:

Property1 Property2 Property3
IP54 Yellow With lamp 30W
IP20 Blue Without lamp 40W


In the first step I would like get this:
IP54-Yellow-With lamp-30W
IP54-Yellow-With lamp-40W
IP54-Yellow-Without lamp-30W.

(in the next step, I would like to set Properties which are not possible,
for example 60W is not possible if the Color is red)

For this, I have two tables:

Table A
ID Property (color could be value 1, lamp, IPXX, Watt..) integer
POS (in this sequence I would like to generatet he result) integer
ID itself, Integer, self generated.

Table B
ID itself auto generated integer
ID_Table A references to Table A
Property - (yellow, red..)

For example,
Table A
ID Property POS ID itself
1 (Color) 1 10
2(lamp) 2 11
3(Watt) 3 12

Table B
ID itself ID_Table_A Property
101 10 RED
102 10 BLUE
103 10 White
104 11 With Lamp
105 11 Without Lamp
105 12 30 Watt
105 12 40 Watt
105 12 50 Watt

Now I would get:

Red-With Lamp-30 Watt
Red-With Lamp-40 Watt
Red-With Lamp-50 Watt
Red-Without Lamp-30 Watt
Red-Without Lamp-40 Watt
Red-Without Lamp-50 Watt
Blue-With Lamp-30 Watt.. and so on

How can I realize with firebird?

Thank you.

Best regards