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>

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

FROM TPARENT Basically, I have two tables TPARENT and TCHILD. TCHILD has a FK parentid to TPARENT.id. I want a list of all parents and the number of children they have.

Any insights would be appreciated.

Anupriyo

Received on Wed Aug 15 2001 - 21:12:50 CEST

This message: [ Message body ]
Next message: andrea: "Oracle Forms Insert ?? How to..."
Previous message: The Nomad: "Help!! ORA-17011 Exhausted Resultset"
Next in thread: Mark D Powell: "Re: SQLServer to Oracle"
Reply: Anurag Varma: "Re: SQLServer to Oracle"
Reply: salvi: "Re: SQLServer to Oracle"
Reply: Flapper: "Re: SQLServer to Oracle"
Reply: Mark D Powell: "Re: SQLServer to Oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message