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.

## What is theta join in DBMS?

## Answer Question

Click here to Login / Register your free account

## Related Answered Questions

## Related Open Questions