SQL: UNION with local SQL?

Hello everybody!

Is it possible to combine two (or more) paradox-tables with the
SELECT ..... UNION .... statement in local SQL?
I have tried it, but without success.

BTW: Does anybody know where to get a documentation about the
syntax of local SQL?

Thanks in advance for any help!