Nested Select
From: Stephen Massingale <smassingale_at_GoTropics.com>
Date: Tue, 23 Jan 2001 22:27:39 GMT
Message-ID: <vznb6.172279$65.1192332_at_news1.rdc1.fl.home.com>
Date: Tue, 23 Jan 2001 22:27:39 GMT
Message-ID: <vznb6.172279$65.1192332_at_news1.rdc1.fl.home.com>
Hello,
I have a nested select statement (simple version listed below) that runs
under Oracle 8i (release 2) but not under 7.3.4. Is there any way to
reformat this to run under both versions? Thanks...
SELECT PU.POLICY_YEAR, PU.policy_version, PU.insured_unit_no, (SELECT COUNT(0) FROM NOTEPAD WHERE NOTEPAD.Policy_Id = PU.policy_id AND NOTEPAD.POLICY_UNIT = PU.POLICY_UNIT AND note_type = 'POL') AS NoteCount FROM POLICY_UNIT PU WHERE PU.company_no = 100 AND PU.insured_no = 143
Stephen B. Massingale
Vice President, Software Engineering
Tropics Software Technologies
smassingale_at_GoTropics.com
Received on Tue Jan 23 2001 - 23:27:39 CET