SELECT
Goods.name,
out.outdate,
out.indate,
in.incomePrice,
DocType.Descr as pokupka,
DocType.Descr as prodaja

FROM out,in,Goods,InMaster,OutMaster,DocType
WHERE
        (outdate  between  :maskedit1 and :maskedit2) and
        (out.Goods_id=Goods.Goods_id)       and
        (Goods.Goods_id=in.Goods_id)       and
        (out.in_id=in.in_id)    and
        (inMaster.InMaster_id=in.Master_id) and
        (in.in_id=out.in_id) and
        (OutMaster.Master_id=out.Master_id factg.factg_k=recg.factg_k)and
	(DocType.doctype_id=inmaster.doctype_id) and
        (DocType.doctype_id=outmaster.doctype_id) 
        


GROUP BY  Goods.name,outdate, indate, incomePrice,

ORDER BY  Out.Out_id

SELECT
Goods.name,
out.outdate,
out.indate,
in.incomePrice,
D1.Descr as pokupka,
D2.Descr as prodaja

FROM out,in,Goods,InMaster,OutMaster,DocType D1,DocType D2
WHERE
        (outdate  between  :maskedit1 and :maskedit2) and
        (out.Goods_id=Goods.Goods_id)       and
        (Goods.Goods_id=in.Goods_id)       and
        (out.in_id=in.in_id)    and
        (inMaster.InMaster_id=in.InMaster_id) and
        (in.in_id=out.in_id) and
        (OutMaster.OutMaster_id=out.OutMaster_id) and
	(D1.doctype_id=inmaster.doctype_id) and
        (D2.doctype_id=outmaster.doctype_id) 
    
GROUP BY  Goods.name,outdate, indate, incomePrice, D1.Descr, D2.Descr
ORDER BY  Out.Out_id