on 12-19-2018 9:09 AM
Dear Team,
Schema name is A_GM
SELECT 'IC Pymt' "DocType", T0."CardCode", T0."DocDate", T0."DocTotalSy",T0."CheckAcct", T0."BPLName", T0."CashAcct", T0."Canceled", T1."CardName", T1."City", T1."CardType", T1."State1",T2."GroupName", T3."AcctName" FROM "A_GM"."OVPM" T0 LEFT OUTER JOIN "A_GM"."OCRD" T1 ON T0."CardCode" = T1."CardCode" LEFT OUTER JOIN "A_GM"."OCRG" T2 ON T1."GroupCode" = T2."GroupCode" LEFT OUTER JOIN "A_GM"."OACT" T3 ON T0."CardCode" = T3."AcctCode" UNION ALL SELECT 'IC Pymt' "DocType", T0."CardCode", T0."DocDate", T0."DocTotalSy",T0."CheckAcct", T0."CashAcct", T0."Canceled", T0."BPLName", T1."CardName", T1."City", T1."CardType", T1."State1",T2."GroupName", T3."AcctName" FROM "A_GM"."ORCT" T0 LEFT OUTER JOIN "A_GM"."OCRD" T1 ON T0."CardCode" = T1."CardCode" LEFT OUTER JOIN "A_GM"."OCRG" T2 ON T1."GroupCode" = T2."GroupCode" LEFT OUTER JOIN "A_GM"."OACT" T3 ON T0."CardCode" = T3."AcctCode"
Please find the screenshot for the error.
Hello Florian,
Thanks for the reply,I just rechecked the query i forgot to put semicolon at the end of the query.
Now error is gone thank you.
Best Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.