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 this some years ago in Oracle
and I would liki to know if it is possible in mysql.
Thanks
joao
__________________________________________________________
Sabe quanto gasta com a sua ligação à Internet?
Verifique aqui: http://acesso.portugalmail.pt/contas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
