Hee: sql - Updating all columns of a table -

Thursday, 15 April 2010

i using ms access connect linked oracle database. have table b pulls columns table (in linked db).

i trying execute macro runs query1 update table b info changing.

the 2 not related id, update table command doesn't seem logical me. should using join? need place launch query from.

based on give-and-take in comments, sounds table b "view" on table a. not confident need update query.

in ms access, the syntax create view thus:

create view my_view select col1, col2 [table a]

sql oracle ms-access

Hee