Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table Joins

 

Performing SELECT Statements that Use More than Two Tables

Joins can be used to connect any number of tables. The number of joins you will need in your WHERE clause is total_number_of_tables - 1 There are two types of join conditions, which are based on the operator. Equijoins - You use the equality operator (=) in the join. Non-equijoins - You use an operator other than equals in the join, such as , BETWEEN, and so on.