SELECT
  CS.GroupName AS ProspectName,
  CS.DateJoined AS ClientDate,
  7 AS OriginID,
  HO.LabourNetBranchID,
  CS.IndustryID,
  CS.SetaID,
  CS.PaymentMethod,
  CS.EstTurnOver
FROM
  taClients AS CS
    LEFT JOIN taClientBranches AS HO ON ((HO.ClientID = CS.ClientID) AND (HO.IsHeadOffice = 1) AND (HO.BranchStatus = CS.ClientStatus))
WHERE
  (CS.ClientID = @nClientID)
