Hi. I have a table with two foreign keys (1 field each), like in id | serial ext_key_original | integer ext_key_exception | integer
They mean different things, as one refers to a typical value, and the other one refers to an exception that applies for that tuple. Each key references a different table, one with typical data, and one with exception data. I'd like to join on the original, except when exception <> NULL, but I can't quite figure out how to do so. Can anyone help? Thanks you. :-) Octavio. -- Octavio Alvarez. E-mail: [EMAIL PROTECTED] Agradezco que sus correos sean enviados siempre a esta dirección. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
