bonjour,
Le vendredi 09 juillet 2004, Jos� R�mulo El�as Contreras a �crit...
> UPDATE items,month SET items.price=month.price WHERE
> items.id=month.id;
may be:
UPDATE ITEMS SET PRICE =
(
SELECT M.PRICE FROM MONTH M, ITEMS I
WHERE M.ID = I.ID
)
--
jm
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
