>I'm pretty sure of the respond but, is there a way to make (like) a join
>between a remote and a local table using SQLExec. The way I did is I do a
>scan from the local table and I go retrieve the info. I want from the remote
>table. I hope there is a better solution. Thanks!

SQLExec will retrieve a cursor, and this cursor can be joined to local table. I am not sure, it's what you are asking...