SELECT `r` . `DetailId` , `u` . `FirstName` , `u` . `LastName` , `r` . `FAPId` , `r` . `IsActive` , `r` . `IsDeleted` , `r` . `RoleDescription` , `r` . `RoleName` , `r` . `MaxAlloweduser` , `u` . `RoleStr` FROM `Role_Details` AS `r` INNER JOIN `User_Master` AS `u` ON `r` . `FAPId` = `u` . `Id` 