今天说一个典型的应用：外协在购订单上的料号是一个SUB的专用料号(每家外包供应商一个)，如果想知道这些采购订单对应的成品和数量，就得自己弄报表来实现，下面是关键代码。
function get.production.order.and.part.numnber()
{
select tdpur402.*,tisfc001.*
from tdpur402,tisfc001
where tdpur402.orno = :tdpur401.orno
and tdpur402.pono = :tdpur401.pono
and tdpur402.pdno = tisfc001.pdno
order by tisfc001._index1
selectempty
tisfc001.pdno = ""
tisfc001.mitm = ""
endselect
}
