What is theta join in DBMS?

Showing Answers 1 - 3 of 3 Answers

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.

  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