LEFT JOIN on one and/or another column - Mailing list pgsql-sql

From Octavio Alvarez
Subject LEFT JOIN on one and/or another column
Date
Msg-id 1533.63.84.67.25.1075350420.squirrel@alvarezp.ods.org
Whole thread Raw
Responses Re: LEFT JOIN on one and/or another column
List pgsql-sql
Hi. I have a table with two foreign keys (1 field each), like in
id                | serialext_key_original  | integerext_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: alvarezp@alvarezp.ods.org.

Agradezco que sus correos sean enviados siempre a esta dirección.


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question about isolation
Next
From: "Kumar"
Date:
Subject: SQL Query for Top Down fetching of childs