Two select query in sender JDBC adaptor

[swatantra_vijay3]

Hi

We are doing JDFC-RFC scenario, in which i need to fetch the data from two tables (header and item table) whch correspondes to the 2 table parameter of RFC .

Any clues how to configure sender jdbc CC having 2 select query ??????

Regards

Vijay

[justin_santhanam]

Swatantra,

You can have a look at the below URL for more info on JOIN.

http://www.w3schools.com/sql/sql_join.asp

Best regards,

raj.

[Former Member]

Hi;

You can do this using:

1: Using a Join in the select query.

2:Using Coorelation between the two tables and fetch the records in 2 steps.

Mudit

[bhavesh_kantilal]

You can only have one select Query.

Try to use a JOIN SQL Statement .

Regards

Bhavesh