Обсуждение: outer joins

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?

On Sat, 3 Feb 2001, Culley Harrelson wrote:

> 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?

Outer joins are avaialble in the 7.1 release (which is currently in
beta).  They will use standard SQL92 syntax.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Hardware, n.:
    The parts of a computer system that can be kicked.