Hi Alan.

>How can I specify an alias for a table name in the join condition?

We don't currently support this (although you could change that behavior yourself if you're so inclined), so we recommend folks use a view that does the join you want and report on the view. However, we're planning to add this feature to SFQuery and SFReports in a future release.

Doug