ERROR [37000] [PxPlus][ODBC Driver]Expected lexical element not found: FROM
trying to push this code to workbench, can anyone help me how this can be pushed through workbench without having "ERROR [37000] [PxPlus][ODBC Driver]Expected lexical element not found: FROM" select o.*, isnull(c.Qty,0) as CancelQty, isnull(s.Qty,0) as ShipQty from ( -- ORDERED -- SELECT ORS_ORDN, ORS_LINE, ORS_CHGN, Size,…
