Added a test for JOINS.