VIEW view intersect

view view intersect view2

Returns a new view with rows that are the set intersection of the rows in view with the rows in view2. This command assumes that neither view nor view2 have any duplicate rows. In that case, then the returned view will also have no duplicate rows.

See [view view unique]

DGP