Hi,
This is likely a silly question, but probably I have been staring at SQL
queries for too long, and using too many database systems at once:
How can I do a multi-table update?
More specifically something like:
UPDATE table1
FROM table2
SET table1.field1=table2.field1
WHERE table1.key = table2.key
I have tried all of the syntaxes I know, and none seem to be working?
I even tried something like:
UPDATE table1
SET table1.field1=(SELECT field1 FROM table2 WHERE table1.key =
table2.key)
The errors haven't been constructive, and the help hasn't been helpful. I
didn't see any previous posts about this, and I don't remember having
problems with it before.
db version is 7.4.03.14
Thank you,
Noah Silva
Atofina IS&T - Sr. Programmer Analyst
(215) 419 - 7916
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
