select
object_date, object_sc
from
object_blob ob1
where
object_id = :object_id
and blob_type_id = 7
and object_date =
(select max(object_date)the_date
from object_blob ob2
where
ob2.object_id = ob1.object_id
and ob2.blob_type_id = 7
);

regards
Russell



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com