Semijoin
Description
A semijoin returns rows that match an
EXISTS
subquery without duplicating rows from the left side of the predicate when multiple rows on the right side satisfy the criteria of the subquery. Semijoin transformation cannot be done if the subquery is on anOR
branch of theWHERE
clause. (Oracle SQL Language Reference Semijoin Subsection)
Sample Source Patterns
Basic Semijoin case
Oracle
IN -> Oracle_01.sql
Snowflake
OUT -> Oracle_01.sql
Known Issues
No issues were found.
Related EWIs
No related EWIs.
Last updated