Hi, Have you tried first to make an view of the select you use in the from clause ?
create V1 as select f1,f2.f3 from T1 where F4 = 4711 create V2 as select anything FROM V1,...... WHERE ...... regards jph ___________________________ Dipl.-Ing. Jens-Peter C. Hillers Remote Web Services GmbH Tel: +49 40 25 49 06 22 Fax: +49 40 36 00 67 27 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ____________________________ > -----Ursprüngliche Nachricht----- > Von: Michael Hennessy [mailto:[EMAIL PROTECTED] > Gesendet am: Montag, 1. August 2005 08:22 > An: maxdb@lists.mysql.com > Betreff: Question about : "Not yet implemented:SELECT IN FROM PART OF > VIEW" > > > Hi all, > > I've got a maxdb v7.5.0 install and am getting this error when I try to > create a view that is based on a query statement with a select in its FROM > part: > > "Not yet implemented:SELECT IN FROM PART OF VIEW" > > Does anyone know if any of the later versions implement this as yet? > > Thanks in advance for any help. > > regards, > > Michael Hennessy > > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
