Table pruning though a view

  • Create two tables with a column primary key
  • Create a view joining this two tables through this key
  • Selecting only columns of one tables must select only one table (pruning the second one).

Reference