iasritesh

 Profile Answers by iasritesh Questions by iasritesh

• Jan 14th, 2007

 

Theta Joins  Theta joins are joins that use any of the comparison operators:

• Greater than, denoted by >
• Greater than or equal to, denoted by >=
• Less than, denoted by <
• Less than or equal to, denoted by <=
• Equal to, denoted by =
• Not equal to, denoted by != or <>

Joins that are not equijoins are often described informally as a "less-than join," or "greater-than join," and so forth.

Thanks n Regards,

Ritesh