SELECT dbo.ReportType.name FROM dbo.Center INNER JOIN dbo.SwitchType ON dbo.Center.SwitchTypeID = dbo.SwitchType.SwitchTypeID RIGHT JOIN dbo.ReportType ON dbo.SwitchType.SwitchTypeID = dbo.ReportType.SwitchTypeID WHERE (dbo.Center.CenterID = 1) OR (dbo.ReportType.SwitchTypeID IS NULL)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)