selecting data from multiple tables from Oracle - Select statement

[Former Member]

Hi Team,

There is a requirement like:

As soon as new data gets inserted in to the stagging tables(two tables, Header and Detail table). XI has to select those newly added , updated data from this two tables. and map it to IDOC.

To achieve this requirement of immediately pulling data from these two tables as soon as data is inserted or updated:
Either we can have stored procedure, 
We can write query in select stement  and set polling interval accordingly. --- Can we write join query in select statement  under JDBC sender adapter?

XI version : XI 3.0

Please suggest your inputs on this.

Thanks in Advance.

Div

[MichalKrawczyk]

Hi,

>>>an we write join query in select statement under JDBC sender adapter?

yes you can

Regards,

Michal Krawczyk