Re: select's with various levels

2005-05-04 Thread Eric Bergen
It's possible starting with mysql 4.1 -Eric [EMAIL PROTECTED] wrote: Dear all at mysql list I'dd like to know if it is possible (and the right sintax) to execute a nested (2 or more levels) select... something like this. select * from products where productId IN ( select idNumber from othe

select's with various levels

2005-05-04 Thread joao . miguel . ferreira . 19740720
Dear all at mysql list I'dd like to know if it is possible (and the right sintax) to execute a nested (2 or more levels) select... something like this. select * from products where productId IN ( select idNumber from other_table ); This has the same result than a JOIN. I've done