Query For GRPO

Hi all,

i want a report for GRPO, the query that i have made is as mentioned below;

Select Docnum as Num, U_Gateno as Gate ,Docdate as Date, CardName as Party, U_Billno as Bill, DocDate as Date from opdn

Select Dscription as Item, Quantity as Qnty,unitMsr as Unit, Taxcode as vat from pdn1

now apart from these, i want the "unit price" and the "total" which are variables. Also can anyone please help me how to join these SQL to get a single row report?

Thanks in advance,

Joseph Antony