Dear All,
SELECT T0."DocNum", T0."DocDate", T0."CardCode", T0."SuppName", T1."Dscription", T0."DocTotal" FROM OIPF T0 INNER JOIN IPF1 T1 ON T0."DocEntry" = T1."DocEntry" WHERE IFNULL( T1."TargetDoc",'')=''
any one can help ?
