Joins

select attributes from r1, r2 where r1.attribute=r2.attribute

Joins are done using foreign keys.

A join can also be explicitly specified as follows:

select * from r natural join s