Hello,

 

I thought Database Query Monitor has restriction that multiple tables cannot be joined in a sql. When I read it for AM9, there is no description about it. Can I write and put a sql like below to use Database Query Monitor?

 

Thank you.

 

kkami_me

 

example:

 

select rownum,
a.schedule_date,b.order_id,c.order_type_desc,b.order_status
from tablea a,tableb b,tablec c 
where
a.order_id = b.order_id
and
b.order_type = c.order_type
and
b.order_status not in ('CLSD', 'NSCH','CANC')
and
sysdate >= (a.schedule_date + 60 / (24*60))