Hi,

May be a stupid question, but is it possible to JOIN a certain record based on a column value?

TABLE: PRODUCTS(ID,PRODUCT_ID,PRODUCT_TYPE)
PRODUCTS(1,1,1)
PRODUCTS(1,1,2)
PRODUCTS(1,1,3)

TABLE: PRODUCT_DETAILS_1(1,"aaa")
TABLE: PRODUCT_DETAILS_2(1,"bbb")
TABLE: PRODUCT_DETAILS_3(1,"ccc")

I want to create a query that joins all records in TABLE PRODUCTS to the respective PRODUCT_DETAILS_x TABLE:

If(PRODUCTS.PRODUCT_TYPE = 1)
LEFT JOIN PRODUCT_DETAILS_1 ...
If(PRODUCTS.PRODUCT_TYPE = 2)
LEFT JOIN PRODUCT_DETAILS_2 ...
If(PRODUCTS.PRODUCT_TYPE = 3)
LEFT JOIN PRODUCT_DETAILS_3 ...

etc.

Maybe this or this can help.