JOIN OPERATOR The JOIN operator specifies how to relate tables in the query. The JOIN operator is one of the set operations available in relational databases. The following join types of join are available in most relational databases: INNER OUTER (LEFT. RIGHT, FULL) CROSS Joins may be represented as Venn diagrams, as shown below along with other common set operations: Result of applying these jo