There were some comments about finding a good use for cross joins.  Cross joins followed by a left outer join just like this one are very powerful when building cross-tab...