Is there a way to get crystal to perform a query for every row in the result of another query? This will be needed many times on the same query so nested queries are not maintainable.

For example I execute:
SELECT username, SUM(foo)
FROM someTable
WHERE status = 1
GROUP BY username

But for every user, I would also like to get their email, from say:
SELECT email
FROM someOtherTable
WHERE username = thisUser

Using JOINS are also not efficient with aggregated data.