That is definately a Sergey Berezniker's question :o))))
But let me try. I think easist way is to create an SP in backend Base that joins theese tables and then invoke it by
SQLEXEC(handle,"EXEC MySP","MyJoinedCursor").
I don't know if this helps but You can look at
"How to make SQL Pass-Through cursor updatable" FAQ #8153
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.