SELECT `a` . `Id` , `a` . `UserId` , `u` . `Id` AS `FapId` , `u` . `FirstName` AS `FAPName` , `a` . `AuditScheduleTitle` AS `AuditName` , `a` . `AuditScheduleDescription` AS `Description` , `a` . `ComplianceType` , `a` . `SAAssessmentType` , `a` . `IAAssessmentType` , `a` . `EAAssessmentType` , `a` . `SMAssessmentType` , `a` . `AssessmentById` , `a` . `IsCompleted` , `a` . `IsActive` AS `IsActiveAudit` , `a` . `IsDeleted` AS `IsDeleteAudit` , `s` . `ScheduleId` , `s` . `TotalNoAudit` AS `TotalAudit` , `s` . `ScheduleDate` , `s` . `IsActive` AS `IsActiveSchedule` , `s` . `IsDeleted` AS `IsDeleteSchedule` , `s` . `IsSuspended` AS `IsSuspendedSchedule` , `s` . `ScheduleStatus` , `s` . `IsCompleted` AS `IsCompletedSchedule` , `a` . `Createdby` , `s` . `StartDate` , `s` . `EndDate` , `u` . `OrgEmailId` AS `OrgEmailAddress` , `s` . `IsEdited` FROM `Audit_Schedule` AS `a` INNER JOIN `Schedular_Master` AS `s` ON `a` . `Id` = `s` . `AuditId` INNER JOIN `User_Master` AS `u` ON 