On Wed, Jan 28, 2004 at 20:27:00 -0800, Octavio Alvarez <[EMAIL PROTECTED]> wrote: > > 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.
I am not completely sure from your description what exactly you are trying to do, but it sounds like you can left join your table to the two foreign key tables and then use coallesce to grab the value from the appropiate joined table. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
