Re: SQLServer to Oracle
From: Flapper <flappersbits_at_hotmail.com.NOSPAM>
Date: Thu, 16 Aug 2001 11:21:34 +0100
Message-ID: <m8Ne7.1797$YS6.8129_at_NewsReader>
Date: Thu, 16 Aug 2001 11:21:34 +0100
Message-ID: <m8Ne7.1797$YS6.8129_at_NewsReader>
select
p.id, p.name, count(*) cnt
from
parent p, child c
where
p.id = p.id
group by
p.id, p.name;
-- FlapperReceived on Thu Aug 16 2001 - 12:21:34 CEST