Thank you Brian,
I have updated my script to be more functional. Much Appreciated. Hope this helps some other people.
select dbo.usrmst.usrmst_fullname as 'Full Name', usrmst_name as 'User Name', dbo.secmst.secmst_name as 'Security Profile', usrmst_suser as 'Super User'
join dbo.secmst ON usrmst.secmst_id = dbo.secmst.secmst_id
where usrmst_suser = 'y' or dbo.secmst.secmst_name like '%%'
order by usrmst_fullname asc