David
> > (I think Davids version was wrong)
> >
> ... not wrong, just not as correct as your version!
I also had a twinge after I posted thinking that may have been a valid MS
SQLism
The Subselect is the most 'portable' but also the most inefficient. I
remember
doing lots of updates like this in FlexQL which was totally pervsere, There
was no
syntax to do this directly but you could create a view (joining the tables)
and then update the view!
also I was stumped by MS SQL's handling of the joined version in 6.5 it
'worked' ie didn't error,
but only updated the first row!
Neven
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
