update statement using multiple tables?

[=?ISO-8859-1?Q?Jos=E9_R=F3mulo_El=EDas_Contreras?=]

Hi:
      How can I do something like this in SAPDB:
        UPDATE items,month SET items.price=month.price WHERE items.id=month.id;
Thanks.
                 

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]