select a.imageno, b.imagetypename from imageproperty_t a left join imagetype_t b on
a.imagetype=b.imagetype where a.archno=(select archno from archflow_t where archbcid='' )
'exec GetImage '' ' + ADODataSet1.FieldByName('IDBName').AsString + ' '','' ' + ADODataSet1.FieldByName('IUID').AsString + ' '' ')
select b.imagetypename,a.imageno,a.isorg,a.isbl,a.imagebak from imageproperty_t a left join imagetype_t b on a.imagetype=b.imagetype where archbcid='0000000000002' and imageno in (select min(imageno) from imageproperty_t where archbcid='0000000000002' group by imagetype)
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。