How to join two ODS for query

Dear All,

I have one scenario, where I need to add two ODS. One ODS containing Customer and Marketing Program information, wheras another ODS contains information about agreement , customer and marketing program. So we need one BW query report Which will show all the list of Customer assigned with Marketing program and shows its corresponding agreement value if assigned and not assigned.

I am not able to get this result through Multi-provider as it is showing only those marketing prgm,whose having agreement. Please suggest what need to do?