Thing about joins, is that they don't even need to be true tables... they can be sub-queries, views, functions, etc...

-tg