Joins in multiple tables JDBC sender

[Former Member]

Hello,

I have 3 tables M1, M2, M3. M1 and M2 are linked by a key m_id. M2 and M3 are linked by n_id. I need to write a join for a JDBC sender linking M1, M2 and M3. Any advise?

Sam

[VijayKonam · Accepted solution]

You need to basically write a SQL query joining the tables. Nothing related to XI specifically. That requires just SQL query expertise..!!

VJ

[Former Member · Accepted solution]

Thanks. Any sample queries available based on my tables and key fields. I would really appreciate it.

Sam

[Former Member · Accepted solution]

Hi Sam,

> Thanks. Any sample queries available based on my tables and key fields. I would really appreciate it.

Select <f1,f2,.. m_id, n_id...fn> from M1 M2 M3 where M1.m_id = M2.m_id and M2.n_id = M3.n_id.

Here f1,....m_id,n_id,.....fn are fields.

For more referrence check this link

http://www.psoug.org/reference/joins.html

Regards

Ramesh

[Former Member]

Hi,

You can write the query mentioned in this link as an example:

http://databases.about.com/od/sql/a/multiple_joins.htm

http://www.codeguru.com/forum/showthread.php?t=382050

Regards,

---Satish