• I tried this in QA and I got the following error message...

    View or function 'MyOrders' is not updatable because the modification affects multiple base tables.

    This would suggest that the answer "You cannot do this as the view contains multiple tables." is more correct than "You cannot do this as the update references two tables."

    just my two cents...