Selects within selects - problem with group bys.

From: Matthew Barrett <matt_barrett_at_tesco.net>
Date: Wed, 18 Jul 2001 07:53:22 +0100
Message-ID: <hga57.45815$WS4.7062781@news6-win.server.ntlworld.com>

Hi all,

I am having a problem converting some of my views from syabase to oracle 8i standard:

They are basically a select within a select, e.g.

CREATE OR REPLACE v_MyView (fielda,fieldb,fieldc,fieldd) AS

SELECT A,B,MAX(c),(SELECT V FROM TBLX WHERE T = A)

FROM TBLY GROUP BY A,B; I get an error basically saying that the (select v from tblx where t= a) needs to be in the group by,

however, there is no way I can get it into the group by, also I don't want to group by fieldd.

Any help would be much appreciated, as this will solve halve of the views I am having problems with.

Thanks.

Matthew. Received on Wed Jul 18 2001 - 01:53:22 CDT