SELECT
  BR.BranchID,
  BR.BranchRegion,
  BR.BranchName,
  COALESCE(S1.OptionDescription, '') AS Province,
  BR.TrackingCategory,
  BR.Status,
  U1.FullName AS BranchManager
FROM
  taBranches AS BR
    LEFT JOIN taUsers AS U1 ON (U1.UserID = BR.BranchManagerID)
    LEFT JOIN taSystemOption AS S1 ON ((S1.OptionType = 'PROVINCE') AND (S1.OptionID = BR.ProvinceID))
