>>if you ask me - mine is much simpler than the one you listed above- you have 5 SELECTS 4 of which are sub queries and mine has two simeple ones.
>>the only diff is I didn't use shortcuts for table names
>>
>>IAC , whatever you got that works is good for you
>
>Hmmm... Maybe it just seems more complicated since I don't know how to do joins and unions... Selects I get, so that seems simpler.

instead of using a JOIN you can implement this with WHERE
you may want to learn how to use JOINs though, because you can also have OUTER JOINs then, also it is more close to ANSI SQL syntax

Arnon