Oracle Semi Join | Semi Join - oracle tutorial - sql tutorial
What is Oracle semi join ?
- A semi-join returns one copy of each row in first table for which at least one match is found.
- Semi-joins are written using the EXISTS construct.
Oracle Semi Join Example
- Let's take two tables "wikitechy_departments" and "wikitechy_customer"