Vijay Sharma wrote:
> 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_vie
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_ta