Thursday, 17 June 2010

Can you insert into views that are based on joins?

it is possible, provided that your insert statement has a column list that makes it clear there's only one table involved.

You cannot insert into multiple tables with a single insert on a view.

No comments:

Post a Comment