Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
SELECT reportusercredential.id, reportusercredential.username, reportuserpermission.id as reportuserpermissionid, reportusercredential.password, reportusertype.id as usertypeid, Section.id as sectionid, reportusertype.name as usertypename, Branch.name AS branchname, Section.name as sectionname, SELECT STUFF((SELECT ',' + name FROM Branch b where ru.branchid = b.id FOR XML PATH ('')), 1, 1, '') as branchname1 FROM reportusercredential,reportuserpermission ru, Section, Branch b, reportusertype WHERE reportuserpermission.reportuserid=reportusercredential.id AND reportuserpermission.sectionid=Section.id AND reportuserpermission.branchid = Branch.id AND reportusertype.id = reportusercredential.usertypeid AND (('1'='1')) GROUP BY reportusercredential.id
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.