On Friday 21 February 2003 09:16, kk wrote:
> You may have to wait until version 4.1 if I am not mistaken.
You are not mistaken. Subselects will come in 4.1
>
> - Original Message -
> From: "geeta varu" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, February 21, 2003 4:09
On Tuesday 10 December 2002 07:48, Amittai Aviram wrote:
> Sorry! I meant UPDATE, not INSERT!
>
> UPDATE administrators SET id =
> (SELECT id FROM faculty
> WHERE lastName = "Jones")
> WHERE ordr = 1;
You can use multi-tables updates from 4.0.2
In earlier versions use programming languages.