SELECT
  PB.ProspectID,
  PB.ProspectBranchID,
  PB.BranchName,
  PB.PhysicalAddress,
  PB.IsHeadOffice,
  PB.LabourNetBranchID,
  PB.RoundTripDistance,
  PB.NoOfEmployees,
  BR.BranchName AS LabourNetBranchName
FROM
  taProspectBranch AS PB
    LEFT JOIN taBranches AS BR ON (BR.BranchID = PB.LabourNetBranchID)
WHERE
  (PB.ProspectID = @nProspectID)
ORDER BY
  BR.BranchName,
  PB.BranchName
