SELECT Users.*,UserRole.UserRoleLinkId FROM Users LEFT OUTER JOIN UserRole ON Users.UserId=UserRole.UserRoleId and UserRole.UserId=10 where RecordType='R'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)