updaet trouble

[Jeff98]

What is wrong with following code?
I want to get a updated table of renewals (ten columns)with two fileds of sales_type and sales_representative updated.
but it comes out with a table with only two columns.
Thanks.

Jeff

UPDATE renewal06, purchases_all

SET renewal06.sales_type = purchases_all.sales_type, renewal06.sales_representative =purchases_all.representative

WHERE renewal06.sales_type="Renewals" and renewal06.Merchant_ID=purchases_all.Merchant_ID and purchases_all.Contract_Type="New";

 

[Golom]

Are you running this from the query window? If so note that the "View" option doesn't actually run an action query. It converts it to a SELECT to show you what would be the result of running the action query.

You need to use the "Run" icon (!) to perform the update. Alternatively you can save the query and then double-click on it from the query window to run it.

 

[Jeff98]

THX. Golom,
my first time to run update on query window.

Jeff