Richard,
A tip for you.. If I may. 
Go into Enterprise Manager, Your Database, Views.. Create a new View (you are not going to save it).. But anyway, it will give you the results you are looking for in a Microsft Access kind of way. However, the results will work perfectly in SQL.
BTW, you can you also work with SQL Server using Access under a .ADP File format too.
Kent
