on 08-03-2007 5:44 PM
Hi All,
Can we access more than 1 table in one JDBC adapter? If yes how?
XIer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, we can,you want on sender or receiver side?
Thanx
Aamir
I want it on the both sender and receiver side...
Hey
on receiver side create multiple STATEMENT Level tags, one for each table and the appropriate access level tags.
on sender side you can only have one select Query.
so try to use a JOIN SQL Statement .
Message was edited by:
Aamir Suhail
If you want on sender side, then u have to use JOIN's query in order to retrieve the values.
Best regards,
raj.
Could you pls give an example of a JOIN query?
Hello,
This is the best place to learn:http://w3schools.com/sql/sql_join.asp
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.