Re: MySQL 4.1 subqueries!

2003-10-24 Thread Victoria Reznichenko
Simon Gentile <[EMAIL PROTECTED]> wrote: > in version 4.1 states it supports subqueries like > > SELECT * FROM t1 WHERE (1,2,3) IN (SELECT a,b,c FROM > t2); > > it doesn't support 'IN' > > [Dissertation] ERROR 1235: This version of MySQL > doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

Re mysql 4.1 subqueries

2003-10-23 Thread Simon Gentile
i implemented a very simple subquery using 'IN' and i get the same message "Dissertation] ERROR 1235: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'" other subqueries DO work, but i cant get one to work with 'IN' __

Re: MySQL 4.1 subqueries!

2003-10-23 Thread Director General: NEFACOMP
st need to check the manual. Thanks Emery - Original Message - From: "Simon Gentile" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 23, 2003 11:59 Subject: MySQL 4.1 subqueries! > in version 4.1 states it supports subqueries like > > SELE

MySQL 4.1 subqueries!

2003-10-23 Thread Simon Gentile
in version 4.1 states it supports subqueries like SELECT * FROM t1 WHERE (1,2,3) IN (SELECT a,b,c FROM t2); it doesn't support 'IN' [Dissertation] ERROR 1235: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' ___