开窗设计器(adzi210 或 c.q)
在SQL指令中,
SELECT DISTINCT <field>xmdtdocno,xmdtdocdt,xmdtstus,xmdt002,oofa011,xmdt003,ooefl003,xmdtua001,xmdtua002</field>
FROM <table>xmdt_t LEFT OUTER JOIN oofa_t ON oofa002 = '2' AND oofa003 = xmdt002 AND oofaent = xmdtent
LEFT OUTER JOIN ooefl_t ON ooefl001 = xmdt003 AND ooefl002 = :DLANG AND ooeflent = xmdtent</table>
WHERE <wc>xmdtent = :ENT AND xmdtsite = :SITE AND xmdtstus = 'Y'</wc><inwc></inwc>
ORDER BY xmdtdocno
注意WHERE条件:<wc>里面的查询条件在construct和input段都会生效,而写在<inwc>里的查询条件只会在程序input段中生效。
如需添加参数,可见:
SELECT DISTINCT <field>