>I am creating a query where I can't seem to find a way to create it with one SQL Select. I thought before I give up and do it with 2 or 3 SQL selects, maybe someone can see a way.
If you need it for a report (that is, read-only, as opposed to a view), I would suggest not to worry too much about having less statements. Dividing a single SQL - SELECT statement into several parts will quite often make everything much faster.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)