Can an update query update multiple tables?
i.e.
UPDATE
Table1 T, Table2 T
SET
T.ThisField = "this",
T2.ThatField = "that"
??
--
Mark Derricutt | Chalice of Blood
Software Developer | New Zealand Christian Music News
Auckland, New Zealand | http://www.chalice.gen.nz
[EMAIL PROTECTED] | UIN: 1934853
Getting jiggy with Devin Townsend - Soul Driven
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
