>

>.... ON TABLE1.ID_FLD = CASE WHEN TABLE2.ORDER_NO > 0
>                                  THEN TABLE2.ID_FLD
>                             ELSE TABLE3.ID_FLD END
>...
>

Hi Boris,

I'm trying to figure out something similar. I want to JOIN either with Table2 or with Table1 depending on a certain field in Table1.

Say, if Table1.Type = 'R' then I want to join and get fields from Table2 and if Table1.Type = 'S' I want to join with Table3

I can not figure out if this is possible at all.

UPDATE. It's impossible.