Theta join is a type of join operation in relational databases that combines rows from two tables based on a condition that can include any comparison operator. Unlike equi-join, which only uses equality, theta join allows for greater flexibility in defining how tables are related through conditions like less than, greater than, or not equal to.