To observe DataView row actions for an INNER JOIN, complete the following steps:

1. In the textbox containing the view definition statement, change the OUTER keyword to INNER (to define an inner join) and press the Update Definition button to apply the changes.
   
2. Perform the same operations as from DataView Row Actions for an OUTER Join and notice the following changes:
   • When you try to add a view row without assigning some column corresponding to a column from the Order Details DataTable, you get a constraint violation exception concerning the empty ProductID column.
     

     This occurs because the inner join composite view row can only exist if it references the rows from each base DataTable.

   • Click the Yes button and add a value to the ProductID column; notice that the view creates a new row in the Order Details and Orders DataTables.
     
   • When you delete the last child row from Order Details DataTable for the specific parent row, a corresponding view row will be removed, regardless of the existence of a parent row from the Orders DataTable.