Join question - Mailing list pgsql-general

From Williams, Travis L, NEO
Subject Join question
Date
Msg-id AB815D267EC31A4693CC24D234F8291605A0C537@ACCLUST02EVS1.ugd.att.com
Whole thread Raw
Responses Re: Join question  ("Thomas A. Lowery" <tlowery@stlowery.net>)
List pgsql-general
Question,

I have a table (1) with 2 col (a & b) where b can sometimes be null.  I need a query that if B is null I get back the
contentsof A.. but if B is not null I do a join on it and table (2) col c to get the contents of table (2) col d..   I
cando this in multiple queries.. but was wondering if I could do it in 1. 

Travis

pgsql-general by date:

Previous
From: "Clay Luther"
Date:
Subject: Re: left outer join terrible slow compared to inner join
Next
From: Doug McNaught
Date:
Subject: Re: backends