From: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
---|---|
To: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
Subject: | join if there, blank if not |
Date: | 2000-07-12 15:34:04 |
Message-ID: | 01BFEC1E.FF0A43A0@garys.ringways.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi all,
I just can't get my head round this one so I hope one of you can.
I've got two tables, one holding phone calls, and another holding phone numbers.
I want to do a select where if the number in the calls table exists
in the numbers table, the description is included otherwise the
description field is blank.
Unfortunately, using the select I've tried, if the number is not on
the one of the tables, it's ignored.
Calls table
cdate date
ctime time
cextn char(3)
cnumber x(12)
Numbers table
nnumber x(12)
ndesc x(30)
Select I tried.
select c.cdate, c.ctime, c.cextn, c.cnumber n.ndesc
from calls c, numbers n where c.cnumber = n.nnumber;
-----------------------------------------
Gary Stainburn.
Work: http://www.ringways.co.uk mailto:gary(dot)stainburn(at)ringways(dot)co(dot)uk
REVCOM: http://www.revcom.org.uk mailto:gary(dot)stainburn(at)revcom(dot)org(dot)uk
-----------------------------------------
Murphy's Laws: (327) The minute before the engineer arrives, the printer starts working.
-----------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Powell | 2000-07-12 16:24:36 | Bug in to_char() |
Previous Message | Jacques Williams | 2000-07-12 14:41:12 | Re: join if there, blank if not |