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
