Bruno,
> My suggestion:> SELECT t3.id, coalesce(t1.name, t2.name), t1.abbreviation,> coalesce(t1.juris_id, t2.juris_id) from> (t3 left join t1 using (id)) left join t2 using (id);
Cool! I didn't think of that. I'll give it a try.
-Josh