> -----Original Message-----
> I have to join via where as the reporting tool doesn't
> support JOIN keyword... :(

If your reporting tool can use views then create a view from the SQL and use
that.

Rgds

Si Carter
http://www.tectsoft.net/