working with jdbc two table.

[Former Member]

hi,

is it possible to extract data from more than one table from jdbc sender ..........

how we have to configure communication channel for that..

thanks in advance,

jp.

[justin_santhanam · Accepted solution]

JP,

Its possible. But the both table has to be related to together, so that using join query u can select from more than one table.

Best regards,

raj.

[Former Member · Accepted solution]

hi,

can u give me one example.

thanks inadvance,

jp.

[justin_santhanam · Accepted solution]

JP,

Refer the below URL.

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

Use the same SQL given over ther in the sender JDBC adapter(for example).

Best regards,

raj.

[udo_martens]

Hi JP,

you put a SQL select statement into JDBC sender, so you can ask for more than one table in the FROM clause. A JOIN is possible as well.

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm">Configuring the Sender JDBC Adapter</a>

Regards,

Udo