How can I generate a table Comp{(y,z)} that is a composition of two other separate tables RelOne{(x,y)} and RelTwo{(y,z)}. The rows in each table represent ordered pairs of a many-to-many relationship.
RelOne is
(a, 1)
(b, 1)
(c, 1)
(a, 2)
(b, 2)
RelTwo is
(1, East)
(1, West)
(2, East)
(2...