on 04-24-2015 10:41 AM
Hi,
You can try this query:
SELECT T0.[DocNum], CASE WHEN T1.[InvoiceId] = 0 THEN T0.[DocTotal] ELSE NULL END AS DocTotal, T1.[DocNum], T1.[SumApplied] FROM ORCT T0 INNER JOIN RCT2 T1 ON T0.DocEntry = T1.DocNum
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suphajak,
If you got the correct answer, please close the thread by marking Helpful or Correct answer.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What you mean by return value 1 row? Any example?
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.