MySQL 8.4.2
Source Code Documentation
join_type.h File Reference

Go to the source code of this file.

Enumerations

enum class  JoinType {
  INNER , OUTER , ANTI , SEMI ,
  FULL_OUTER
}
 

Enumeration Type Documentation

◆ JoinType

enum class JoinType
strong
Enumerator
INNER 
OUTER 

Left outer join.

ANTI 

Left antijoin, i.e.

: SELECT projection FROM left_releation WHERE NOT EXISTS (SELECT 1 FROM right_releation WHERE predicate)

SEMI 

Left semijoin, i.e.

: SELECT projection FROM left_releation WHERE EXISTS (SELECT 1 FROM right_releation WHERE predicate)

FULL_OUTER