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?