Is there any way to do anything equivalent to this?
SELECT
..
FROM
tableA t1 LEFT JOIN (IF t1.field1=1, tableB, tableC) t2 ON t1.id=t2.childid
obviously, tableB and tableC will need to have matching fieldnames if they are referenced.
I will probably be chewed out about "why would you want to do that" or how that violates the intent and spirit behind SQL who knows, but there are time where this would be an advantage for me.
And, if it turns out this is NOT possible, are there any similar queries that would join both (or all) tables possibly referenced in context, which would function as one table? I'm open to any suggestions.
Samuel
