Hi,
Sorry for the delay. If there is no alias, does it make a difference? Please let me know.

Anyway, the sql is as follows:

SELECT a.dt_tm, b.data_blob from audit_event a, audit_data_blob b WHERE a.evnt_id = b.evnt_id and a.serv_typ_id =5399 and a.dt_tm > sysdate - 1 ORDER BY a.dt_tm

Thanks.