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

T-SQL |

340 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

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

Comments

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

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

Comments