JCo - Single Search JOIN tables

Hi MDM gurus,

I'm quite new to the MDM JCo API, and I'm trying to do do a search based on two tables.

E.g. I have two tables

Table A has fields F1(key), F2 (foreign key)

Table B has fields F2(key), F3

Is it possible to do 'One single search' on these tables where F1 = F1value

but getting results: A_{F1, A}F2, B~F3 in a ResultSet?

Currently the only way I know to do this is first Search Table A where F1 = F1value.

Loop through the results and Search Table B.

This is very inefficient coding where in SQL or in ABAP you can do this with one line of code.

Any help would be appreciated! Code would be a bonus!

Cheers,

Michael.