>> Can an update query update multiple tables?
>> UPDATE
>> Table1 T, Table2 T
>> SET
>> T.ThisField = "this",
>> T2.ThatField = "that"
> No.
And furthurmore it wouldn't make sense to in this case where there is
no stated relationship between the tables... I thought I saw somewhere
that ORACLE8 (or was it 8i) supported updatable views which can be joins
between tables. (I don't know the syntax nor limitations)... Can anyone
confirm this...
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
