SQLServer to Oracle
From: Anupriyo Chakravarti <anu_chak_at_globalnoise.com>
Date: 15 Aug 2001 12:12:50 -0700
Message-ID: <c0fcc770.0108151112.20329432_at_posting.google.com>
Date: 15 Aug 2001 12:12:50 -0700
Message-ID: <c0fcc770.0108151112.20329432_at_posting.google.com>
This query works in MS SQL Server but not in Oracle 8. Any suggestions how to achieve the samething in Oracle?
SELECT TPARENT.id, TPARENT.name
(SELECT COUNT(*) FROM TPARENT, TCHILD WHERE TCHILD.parentid = TPARENT.id) AS numchildren
Any insights would be appreciated.
- Anupriyo