theta join

Noun

 * 1)  A join between tables based on some relationship other than equality.