Ramco Ramco

Ramco Ramco

  • 435
  • 3.4k
  • 553.5k

Incorrect Syntax near Union

Jan 3 2025 7:29 AM

Hi

  In below code i am getting error 

ELECT 'a' AS "Vendor Code",'b' AS "Vendor Name",'b','d', 'e', 'Opening Balance',v_opgDebit,v_opgCredit

Union All


SELECT T2."CardCode" AS "Vendor Code",T2."CardName" AS "Vendor Name",T2."BPLName",T2."DocNum", T2."DocDate", 'A/p Invoice',0,(T2."DocTotal") + (T2."DpmAmnt") + (T2."DpmVat")
FROM "OPCH" T2
WHERE T2."DocDate" >= TO_DATE(:FromDate) and T2."DocDate" <= TO_DATE(:ToDate)
AND (T2."CardCode"=:BpCode ) 

Thanks


Answers (8)