a) Shortcut join: it is direct join between source and destination
Example: country-->region-> city
We can connect country and city using shortcut join
Theta join: NON equality condition between two TABLES.

B) Short cut Join providing an alternative path between two tables. passing INTERMEDIATE tables, leading to the same result, regardless of direction. Optimizes query time by cutting long join paths as short as possible.
Theta join Link tables BASED on a relationship other than equality between two columns.

a) Shortcut join: it is direct join between source and destination
Example: country-->region-> city
We can connect country and city using shortcut join
Theta join: non equality condition between two tables.

b) Short cut Join providing an alternative path between two tables. passing intermediate tables, leading to the same result, regardless of direction. Optimizes query time by cutting long join paths as short as possible.
Theta join Link tables based on a relationship other than equality between two columns.