Re: MySQL update

Marc G. Fournier kirjutas K, 04.12.2002 kell 18:57:
> On Tue, 3 Dec 2002, Christopher Kings-Lynne wrote:
> 
> > Not that anyone cares, but I notice in the commit logs for MySQL 4.1, it
> > now has subselects.

Any idea _where_ you can use them ?

i.e.is it

select a, (select b from tb) from ta;

or is it

select a from (select a from tb) as ta;

or something else.

Also, can one have correlated subqueries

select a, (select b from tb where a=ta.a) from ta;


-------------
Hannu