SELECT
  CS.GroupName AS ProspectName,
  CS.DateJoined AS ClientDate,
  HO.LabourNetBranchID,
  CS.IndustryID,
  CS.SubIndustryID,
  CS.SetaID,
  CS.PaymentMethod,
  CS.EstTurnOver,
  CS.OrderCompulsory,
  CS.PeasaMember,
  CS.CompanyRegNumber,
  CS.VATNumber,
  CS.TaxTypeID,
  CS.EmailAddress,
  CS.Postal1,
  CS.Postal2,
  CS.Postal3,
  CS.PostalCode,
  CS.BankSortCode,
  CS.BankAccountNumber
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)
