Joins two relations. Merges the tuples of one relation into the other relation into one single tuple.