Okay, not sure best way to try and describe this ... have multiple tables,
of a form like:
table a
gid int
data text
table b
gid int
data text
table c
gid int
data text
table d
gid int
data text
I want to return:
a.gid,a.data,b.data,c.data,count(d.data)
where
a.gid = b.gid = c.gid = d.gid
*but* I want count(d.data) to return zero *if* there are no records in
table d ...
essentially, gid has to exist in tables a,b,c but not d ...
So, ignoring table d, i'd have:
SELECT a.gid,a.data,b.data,c.data
FROM tablea a, tableb b, tablec c
WHERE a.gid = b.gid
AND b.gid = c.gid;
How do I add 'tabled d' to the mix?
Thanks ...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
