update products set unitsinstock=unitsinstock+1 from products inner join categories on products.categoryid = categories.categoryid where categories.categoryname = 'Beverages'>Hi all,
>UPDATE table1 set mycolumn = table2.mymatchedcolumn ; >WHERE (table1.keyid == table2.keyid ) >>
>UPDATE table1 set mycolumn = table2.mymatchedcolumn; >WHERE INDEXSEEK(table1.keyid,.T.,"table2") >