What is theta join in DBMS?

Showing Answers 1 - 3 of 3 Answers


  • 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)


  • 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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions