Re: select's with various levels

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