Joining SQL Server and Paradox Tables

I am using SQL Server 6.5 and I have a few temporary Paradox tables created.

Is it possible to join the two types of tables in a query?

A simple example that I would like to get to work is

SELECT * FROM TABLE1 SQL, TABLE2 PDOX
WHERE SQL.CODE = PDOX.CODE

Any help would be grateful - whether getting the sql to work or information
on if it is better to use temp tables direct in the SQLServer database.

Thanks in advance.

Colin Dunn