select acc.*
FROM Accounts acc
INNER JOIN PrivDefs pd ON acc.Privs = pd.Priv
LEFT OUTER JOIN Sites s ON acc.DefaultSiteID = s.SiteID AND acc.AdminID = s.AdminID
LEFT OUTER JOIN Groups g ON acc.DefaultGroupID = g.GroupID and acc.AdminID = g.AdminID
LEFT OUTER JOIN AccountTemplateAddenda t ON acc.AccountID = t.AccountID
INNER JOIN siteAccess sa ON acc.AccountID = sa.AccountID
where acc.adminID = 188 and
sa.SiteID = 826906
order by AccountID
select acc.*, u.userID, u.MostRecentVisitDate
FROM Accounts acc
INNER JOIN PrivDefs pd ON acc.Privs = pd.Priv
LEFT OUTER JOIN Sites s ON acc.DefaultSiteID = s.SiteID AND acc.AdminID = s.AdminID
LEFT OUTER JOIN Groups g ON acc.DefaultGroupID = g.GroupID and acc.AdminID = g.AdminID
LEFT OUTER JOIN AccountTemplateAddenda t ON acc.AccountID = t.AccountID
INNER JOIN siteAccess sa ON acc.AccountID = sa.AccountID
inner join UserAccountIDs ua on sa.accountID = ua.accountID
inner join Users u on u.userID = ua.userID
where acc.adminID = 188 and
sa.SiteID = 826906
order by AccountID
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE