Sim Zacks wrote:
Elke,
A simple example of the power of including joins in an Update Statement:
Update Tbl1 set tbl1.field1=tbl2.field2*.10, from Tbl1 join tbl2 on tbl1.PKfield=tbl2.tbl1FK
I'm nearly sure you meant something like ... on tbl1.tbl1FK=tbl2.PKfield ?
and then
update tbl1 set field1=(select field2*.10 from tbl2 where tbl1.fkfield=tbl2.pkfield)
works fine
This will update all the joined rows in tbl1 to 10% of the values in tbl2.
I don't see how that is possible using any of the statements you mentioned below. As I mentioned in my earlier post, Access handles the same thing slightly differently. MySQL allows the same thing (from their documentation):
UPDATE items,month SET items.price=month.price WHERE items.id=month.id;
The example shows an inner join using the comma operator, but multiple-table UPDATE statements can use any type of join allowed in SELECT statements, such as LEFT JOIN.
Are you saying that MaxDB can not update on a join?
Thank You Sim ________________________________________________________________________________
-- Georg Thom� IEE Luxembourg S.A. IT dept. / software development / DB-administation tel. 00352/7289896810 fax 00352/7289896109 www.iee.lu / [EMAIL PROTECTED]
This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you are not the intended recipient and have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal from your system. Thank you for your co-operation.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
