On Mon, 2006-05-29 at 12:32 +0200, Nis Jorgensen wrote:
> Rafal Pietrak wrote:
> > But is there a way to achieve one row output with both the count() and
> > its selector, when the ocunt is ZERO?
> SELECT dummy.id, count(xxx.id) FROM (SELECT :id as id FROM dual) as
> dummy LEFT JOIN xxx using (id) GROUP BY id;
>
> You owe the Oracle a natural left join replacement.
Luckily I've already figured that out, after Richard hinted me on using
a JOIN.
Thenx!
--
-R