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