Semi-join Transformation

In several of my prior posts, I’ve given examples of semi-joins.  Recall that semi-joins essentially return a row from one input if we can find at least one matching row from the other input.  Here is a simple example: create table T1 (a int, b int) create table T2 (a int, b int)   set…

0