Go to the source code of this file.
Left outer join.
Left antijoin, i.e.
: SELECT projection FROM left_releation WHERE NOT EXISTS (SELECT 1 FROM right_releation WHERE predicate)
Left semijoin, i.e.
: SELECT projection FROM left_releation WHERE EXISTS (SELECT 1 FROM right_releation WHERE predicate)