Skip to Content
0
May 20 at 04:51 AM

Query for Draft Reports

427 Views Last edit May 26 at 07:02 AM 2 rev

Dear all,

can someone help me to alter this code because if I using Union then the golden arrow won't appear:

SELECT t0.docentry as 'Draft Number', T0.[DocNum], T0.[DocDate], T0.Comments as Remark, T0.U_confirmed, t1.Price<br>FROM ODRF T0  <br>INNER JOIN DRF1 T1 ON T0.[DocEntry] = T1.[DocEntry] <br>WHERE T0.[ObjType] =59 and DocStatus='O' and T0.U_confirmed='No'<br>union all<br>SELECT t0.docentry as 'Draft Number', T1.[DocNum], T0.[DocDate], T1.Comments as Remark, T1.U_confirmed, t0.Price<br>FROM DRF1 T0  <br>INNER JOIN ODRF T1 ON T0.[DocEntry] = T1.[DocEntry] <br>WHERE T0.[ObjType] =59 and DocStatus='O' and T1.U_confirmed='Yes' and t0.Price=0