Do you need exact limitation or only type of limitations?
With exact limitation + title of homepage:
select AccountID AS UserID, AccountEnabled AS Enabled, MenuName AS MenuBar, AllowAdmin AS Admin, AllowNodeManagement AS Manage_Nodes, AllowCustomize AS Customize, AllowReportManagement AS Manage_Reports,
ISNULL(L1.whereclause,'empty') as Limitation1, ISNULL(L2.whereclause,'empty') as Limitation2,ISNULL(L3.whereclause,'empty') as Limitation3,
V.viewtitle AS Home_Page, NodeDetailsViewID AS Node_Details_View from accounts AS A
LEFT join Views as V on v.viewid=A.HomePageViewID
LEFT join Limitations as L1 on A.limitationID1=L1.limitationid
LEFT join Limitations as L2 on A.limitationID2=L2.limitationid
LEFT join Limitations as L3 on A.limitationID3=L3.limitationid
Of course these exact limitation is not good readable.