Retrive data from two diffirent tables

[Former Member]

Hello all,

In my interface source side using JDBC adapter. I need to retrieve data from two different tables. Can anyone suggest me how can i retrieve data from two different tables.

Thanks & Regards,

Venkatk

[Former Member]

Thanks everybody for your response!!

[Former Member]

Hi Venkat,

Hope this too helps:

Cheers,

Manjusha.

[dharamveer_gaur2]

Hi

Sender Data Type Structue would be same format as for single table, Only change in SQL query.

Your Sender structure would be, in your sender data type create required element from table1, table2 and write SQL query in Sender Communication channel.

<resultset>

<row>

<column-name1>value</ column-name1>

<column-name2>Value</column-name2>

<column-name3>value</ column-name3>

<column-name4>value</column-name4>

</row>

</resultset>

Here some column can belong to diffrent table

look this thread to send data from multiple table

You can also use Stored Procedure, look this thread

[Former Member]

Hi Venkat,

Here is the answer:

regards

[dharamveer_gaur2]

Hi

To Select Data From Database you are using Sender JDBC right.

So write a select query that fetch data from two table like Select Employee.EmpId,Account.AccNo from Employee,Account.

[Former Member]

Hi Dharamveer,

In my interface I need to retrieve data from two tables. Sender is JDBC adapter. can u guide me step by step How will i configure sander JDBC adapter.What is the structure of source data types.

Thanks & Regards

Venkat K

[Former Member]

Hi Venkat,

You can use the Join statement or Union operation between two statements.

For Ex:

Select fields from Table1 where Cond1 union select fields from Table2 where cond2.

You can create the datatype based on the fields using in the query statement.

At the Sender adapter use the same statment above.

Regards

Goli Sridhar