Hi,

Is this legal in FB? perform UPDATE operations that cover multiple tables?

UPDATE items, month SET items.price=month.price
WHERE items.id=month.id;

If it is, what Am I doing wrong, as when I try to run it on IBConsole I get
errors regarding the , between table names.

Thanks

daniel

____________________________
Comvision Pty. Ltd.

www.comvision.net.au