JDBC Lookup left join (Lookup on two tables in one query)

Hi,

Is it possible to use the JDBC Lookup in a mapping program to perform a left join query on 2 different tables?

I have imported the External Definition of my 2 tables and for now I have to perfom a JDBC Lookup on the first table and then pass the result to my second JDBC Lookup to get the final value. I would like to do that in one query only.

Thanks,

Martin

Edited by: Martin Lavoie Rousseau on Nov 18, 2010 7:45 PM