cancel
Showing results for 
Search instead for 
Did you mean: 

data from 2 tables for jdbc sender adapter

Former Member
0 Kudos

how to pickup data from 2 tables at a time when using a jdbc sender adapter?

Accepted Solutions (0)

Answers (2)

Answers (2)

prabhu_s2
Active Contributor
0 Kudos

select <fields> from table1 where <condition>

union

select <fields> fromt table2 where <condition>

also u can combine this with joins as pointed

prateek
Active Contributor
0 Kudos

Use Join operation in select query

Regards,

Prateek