I'm slowly getting better at writing complex SQL queries, promise :)

Could somebody help me out by telling me what the SQL would look like to accomplish this task:  Show all users (and registered email address) who are the portal admin for all portals on a  DNN install. 

Thanks in advance :)

Tim, 

      You should ask me I know.  :)

SELECT     Users.Username, Users.Email, PortalAlias.HTTPAlias
FROM         Portals INNER JOIN
                      PortalAlias ON Portals.PortalID = PortalAlias.PortalID INNER JOIN
                      Users ON Portals.AdministratorId = Users.UserID

That will give you the username, e-mail address and portal alias of each of your portal admins.

Cheers,

Champion of the Join and third normal form.  :)