Inner Join Condition For Database Tables in JDBC Adapter

[Former Member]

Hi

Is there any restriction for Number of database tables to Write Inner join Condition in JDBC.

Thanks

[sbhutani1 · Accepted solution]

I dont think there are any restrictions on number of tables in innerjoin, but you need to take care that all the tables must be resides in one database.

Regards

Sumit Bhutani

[justin_santhanam]

Venkat,

No there is no restriction in Inner join. If your query executes perfectly in target Database then the same query will exceute perfectly while calling through XI.

Best regards,

raj.