ΥΠΟΛΟΙΠΑ ΠΕΛΑΤΩΝ

SELECT [EliteUser].[CUA].[NAME]
      ,([EliteUser].[CTO].[FYEDEBIT]-[EliteUser].[CTO].[FYECREDIT]) AS X
  FROM [EliteUser].[CTO]
  LEFT JOIN [EliteUser].[CUA] ON [EliteUser].[CTO].[TRAID] = [EliteUser].[CUA].[ID]
  WHERE FYEID = 1197 AND NAME IS NOT NULL AND [EliteUser].[CTO].[FYEDEBIT]-[EliteUser].[CTO].[FYECREDIT] <> 0
  ORDER BY NAME ASC