Alex,
It requires writing your own SQL queries either in the advanced recordset box that you can open via the server behaviours panel or direct in the code on the page (only recommended if you know what you are doing)
If you need more information on SQL JOINS etc. I would suggest that you get the excellent book Teach Yourself SQL in 10 Minutes by Ben Forta which is an excellent starting point for learning the intricacies of SQL