How can i update all the fields of a view from a table(this is table different from the table which has created the view)? I don't want to specify the name of the columns in the commands e.g i want to do something like this
UPDATE any_view SET (SELECT * FROM any_view) = (SELECT * FROM another_table);
but this query doesn't work.
Whats the way around without specifying the colum name in the SET. In that sense i want to make this query a general query which can update any view from any other table.
