Semijoin Optimization Option
A semijoin between two tables returns rows from the first table whenever one or more matches are found in the second table. The difference between a semijoin and a conventional join is that rows in the first table are returned at most only once, even if the second table contains two matches for a row in the first table.
This section contains: