hi,

I have 2 tables FINAL_TEST and TEMP


FINAL_TEST has 12 fields
TEMP has 2 Fields

FINAL _TEST has 32 Records
TEMP has also 32 Records

I want to update the 2 fields of TEMP to the Column 2 and 3 of FINAL_TEST

I have written the following code but it doesnt work PLEASE ADVICE..ANY HELP WOULD BE APPRECIATED

UPDATE FINAL_TEST SET FINAL_TEST.Sales_Jan = (Select Temp.Sales from Temp where Temp.RowID = FINAL_TEST.RowID), FINAL_TEST.Units_Jan = (Select Temp.Units from Temp where Temp.RowID = FINAL_TEST.RowID);


BR,
Vineeth