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
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