outer joins

From: Culley Harrelson <culleyharrelson(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: outer joins
Date: 2001-02-04 05:38:11
Message-ID: 3A7CEAC3.5E19948@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a better/another way to write this:

select t1.t1_id, (select count(t2.t2_id) from t2 where
t2.t1_id = t1.t1_id) as cnt
from t1

I have gotten in the habbit of returning similar
resultsets via an outer join. What is the scoop on
outer joins? Are they to be included in the next
release or does the syntax already exist? What will
be the syntax for an outer join?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-02-04 05:52:36 Request for speakers at O'Reilly conference
Previous Message Ken Mort 2001-02-04 04:15:16 RE: GIS-type databases using PostgreSQL