re: Re: subselect

2003-02-21 Thread Victoria Reznichenko
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

re: Re: Subselect workaround

2002-12-10 Thread Egor Egorov
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.