You could try something like this;

Cheers,

There probably is but I can't for the life of me remember what it is right now. (Still down one cup of coffee).  The main problem with doing that is there is a one to many relationship between the portalID and the HTTPAlias.  So when I call the portalID for the user I get say PortalID =1, then go to tac on the HTTPAlias and I get results for each entry with a portalID of 1. I'm not 100% sure there is a way to limit that in SQL I would normally take the recordset in code and limit the output  in VB that way I always had all the data I asked for if I wanted to use it later.

I'll keep playing with it though to see if I can remember how. :)  In the mean time you can add an order by clause to make it easier to read;

ORDER BY Users.Username, PortalAlias.HTTPAlias

To sort things by Username and then by Alias.  Just change out Username for other column names to sort by them.