Problem Summary
How do I extract a table based on a join condition because they are dependent tables.
For example:
select <....> from tab1 t1, tab2 t2 where t1.id=t2.id and modified_date >(select max(date) from tab3)
Answer
This can be done by adding a /Restrict action and defining the join condition as the /RefreshCondition as below
/RefreshCondition="where id in (select t2.id from tab2 t2 where modified_date > (select max(date) from tab3))"