Re: Correlated subquery not allowed?

Wed, 09 Mar 2005 12:03:10 -0800 

Forgot to mention:

the view is composed by 4 "union"

Regards,

Edson Richter.


Edson Carlos Ericksson Richter escreveu:

Hi!

Using MaxDB 7.5.0.23, executing following query:

select B.CO_1, B.DS_3,
            (select count(*)
               from TB_1
              where CO_1 = B.CO_1) as NU_ITENS,
            (select count(*)
                 from TB_2 BAA
                  join VI_1 BUG
                    on BAA.CO_1 = BUG.CO_1
                 where DS_U1 = ?
                  and (BAA.ST_1 = 'A' or BAA.ST_1 = 'E')
                  and BAA.CO_2 = B.CO_2) as itsok
       from TB_3 B
      order by B.DS_3

I get "[-7011] (at 51): Correlated subquery not allowed"

If I exchange the view in query by the script contained by view, works fine!

Is this fixed in 7.5.0.24? Any tips appreciated...

Edson Richter



--
Edson Carlos Ericksson Richter
MGR Inform�tica Ltda.
Fones: 3347-0446 / 9259-2993


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to