Hello,
I have written a simple SQL query that returns info about sales returns. I am trying to get the return code description to show up, from the ATABDIV table (Miscellaneous Tables) but it's throwing this notice that the column name, LNGDES_0, does not exist. Any help would be appreciated.
Thank you,
SELECT DISTINCT SRD.SRHNUM_0, SRD.STOFCY_0, SRD.UPDDAT_0, SRD.ITMREF_0, SRD.ITMDES_0, SRD.EXTQTY_0, SRD.QTY_0, SRD.STU_0, SRD.RTNREN_0, ADI.LNGDES_0, SRH.BPCORD_0, SRH.BPDNAM_0, SIV.NUM_0, SIV.REP_0, REP.REPNAM_0, SID.AMTNOTLIN_0, SID.NETPRI_0, SRD.UPDUSR_0 FROM SRETURND SRD LEFT OUTER JOIN SRETURN SRH ON SRD.SRHNUM_0 = SRH.SRHNUM_0 LEFT OUTER JOIN SINVOICEV SIV ON SRH.SRHNUM_0 = SIV.SIHORINUM_0 LEFT OUTER JOIN SINVOICED SID ON SIV.NUM_0 = SID.NUM_0 AND SRD.ITMREF_0 = SID.ITMREF_0 LEFT OUTER JOIN SALESREP REP ON SIV.REP_0 = REP.REPNUM_0 LEFT OUTER JOIN ATABDIV ADI ON SRD.RTNREN_0 = ADI.CODE_0 WHERE SRD.UPDDAT_0 BETWEEN %3% AND %4% AND SRD.STOFCY_0 BETWEEN %1% AND %2% AND ADI.NUMTAB_0 = 7