SELECT
dbo.tblLabourFiles.LabID,
dbo.tblBoardAppointment.OfficerID,
dbo.tblBoardAppointment.DateAppt as [Date Appointed],
dbo.tblSupportStaff.Initials,
COALESCE (dbo.tblSupportStaff.FirstName, '') +
COALESCE (' ' + dbo.tblSupportStaff.LastName, '') AS Officer,
dbo.tblLabourFiles.Disposition as [Final Disposition],
dbo.tblEmployerName.EmpName as [Employer,
dbo.tblLabourFiles.CaseNum + N'/' + dbo.tblLabourFiles.CaseYear +
N'/' + dbo.tblLabourFiles.Act AS [Case],
dbo.tblLabourFiles.DateDec,
dbo.tblLabourFiles.OpenDate,
dbo.tblCaseType.CaseType as [Case Type],
--[ApptType]
CASE WHEN dbo.tblBoardAppointment.InformalAppt = 1 THEN 'Informal Appointment ' ELSE '' END
+
CASE WHEN dbo.tblBoardAppointment.FormalAppt = 1 THEN 'Formal Appointment' ELSE '' END
AS Appoint,
--[SettledWhen]
CASE WHEN dbo.tblBoardAppointment.SettledPrior = 1 THEN 'Settled prior to hearing ' ELSE '' END
+
...
Go to the complete details ...