Updating table from another table


updating table from another table-58

Doc Type Group Thank you for your interest in this question.

I have one table A has column (id, field_1,field_2), and another table B has column (id,field_2) Now I want to merge table B to A, that means i want to update field_2 in table A to value of table B. BTW I am using oracle Thanks Now, each time the above is executed, it will do it across all rows in the table.

Yes, this is a data warehousing query and I'm doing it in MS Access.

So basically I want some query like this: CREATE TABLE Table1 ( id int identity(1, 1) not null, Long Int Column1 int, Currency Column money ) CREATE TABLE Table2 ( id int identity(1, 1) not null, Long Int Column2 int, Currency Column2 money ) INSERT INTO Table1 VALUES(12, 12.00) INSERT INTO Table1 VALUES(11, 13.00) INSERT INTO Table2 SELECT Long Int Column1, Avg(Currency Column) as Currency Column1 FROM Table1 GROUP BY Long Int Column1 CREATE TABLE Table1 ( id int identity(1, 1) not null, Long Int Column1 int, Currency Column money ) INSERT INTO Table1 VALUES(12, 12.00) INSERT INTO Table1 VALUES(11, 13.00) SELECT Long Int Column1, Avg(Currency Column) as Currency Column1 INTO Table2 FROM Table1 GROUP BY Long Int Column1 I believe your problem in this instance is the "values" keyword.

I think this is enough code to make sense of what I'm doing, but if more is needed just let me know and I can post it up as well.