Subqueries in select statements
From: Øystein Johnsen <oystein_at_premium.no>
Date: Tue, 27 Apr 1999 19:03:59 +0200
Message-ID: <3725EDFF.E8E6A387_at_premium.no>
I am very frustrated by the fact that oracle 8.0 does not appear to accept subqueries as expressions, is this really a fact or is there some clever way of doing it?
from table t1
Date: Tue, 27 Apr 1999 19:03:59 +0200
Message-ID: <3725EDFF.E8E6A387_at_premium.no>
I am very frustrated by the fact that oracle 8.0 does not appear to accept subqueries as expressions, is this really a fact or is there some clever way of doing it?
example : select t1.col_a, t1.col_b, (select max(t2.col_c) from table2 t2 where t1.id=t2.id)
from table t1
-- ¯`·.¸¸.·´¯`·.¸¸.·´¯`·.¸¸·´¯`·.¸¸·´¯`·.¸¸·´¯`·.¸¸·´¯`·.¸¸·´¯`·.¸¸·´ The rules of morality are not the conclusion of our reason", David Hume Oystein Johnsen Premium Forvaltningsystemer AS Office: +(47) 224 37 598 Munkedamsveien 68 Mobile: +(47) 928 90 254 0270 Oslo Norway mailto:oystein_at_premium.no ------------------------------------------------------------------Received on Tue Apr 27 1999 - 19:03:59 CEST