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)