Exracting data from two tables existing in external database

Hi SDN friends,

I have 2 tables in external database system. I cannot create a view as I am using Netweaver Java Dictionary. I therefore would like to get the data on BI side & perform join there. TABLE1 & TABLE2 has many to many relationship.

<b>TABLE1</b> - FieldA, FieldB

<b>TABLE2</b> - FieldB, FieldC(texts)

Please help me find the best approach to populate the data into the BI infoobjects.

I assure I will give full points to anyone who replies.

Thanks,

Sunil