In the last episode (Apr 15), Inandjo Taurel said:
> hi,
> i wanted to know from which version will we be able to issue queries like:
> - "select * from table1 where field1 not in (select * from table2)"
This can be rewritten as a left join
> - "select * from table1 where field1 in (select * from table2)"
Same here
> - "select * from table1 where field1=(select field2 from table2 where ...."
This is the easiest. "SELECT table1.* from table1,table2 where
table1.field1=table2.field2 and ..."
> We are actually porting an application written for DBase 4 to mysql, and we
> are facing a lot of issues concerning the non-supporting of some features
> by mysql database (particularly the in/not in statements, the subselects
> and the nested queries! ).
> Thanks.
Mysql 4.1 (currently in alpha) suports subselects, although not very
efficiently yet.
--
Dan Nelson
dnelson@stripped
