SELECT
  CS.ClientID,
  CS.FinNumber,
  CS.GroupName,
  CS.ClientStatus,
  CS.DateJoined,
  SM.NoOfEmployees,
  CS.ContractNumber,
  CS.ContractTerm,
  CS.PaymentMethod,
  SM.ClientRetainer AS RetainerExcl,
  (SM.ClientRetainer * (1.0 + fnVATRateOnDate(NOW(), CS.TaxTypeID))) AS RetainerIncl,
  SM.ClientGroup,
  CS.AdhocAllowed,
  SM.ClientContactsJson,
  SM.ClientProductsJson,
  SM.ClientBranchesJson
FROM
  taClients AS CS
    INNER JOIN taClientSummary AS SM ON (SM.ClientID = CS.ClientID)
WHERE
  (CS.ClientID = @nClientID)
