tarun

• Apr 12th, 2007

 

Theta joins are those joins that use any of the comparison operators(i.e. less than,less than or equal to,greater than,greater than or equal to)

sivaprasad

• Apr 10th, 2015

 

Theta join is nothing but not equi join, i.e.,it is a principle to join two tables with out any common column of both tables.

Lesley Ruzvidzo

• Nov 3rd, 2016

 

Theta join combines tubles from different tables(relation) provided they satisfy the theta condition.
Given R1(A1,A2,A3,...,An) and R2(B1,B2,B3,...,Bn) such that they have no common attributes i.e
R1 intersection R2 (R1 n R2) = Theta.
Theta can use all kinds of comparisons like =,>,< ...e.t.c.