Test left joining in queries.