I think that the easiest way to do this would be to create a view in DB1 that exposes the table in DB2 and then construct the query from DB1 using the view as your DB2 table. Just remember your permissions to avoid possible ownership cross-chaining problems from SP3 installs.
Have you tried using the full 3 or 4-part SQL object qualifier? A remote view is pretty much a pass-thru SQL statement, so it *should* work, as long as the permissions are correct.
Alternately, work in Fox 8 and use a cursor or xml adapter - that should work as well.
Enjoy, and at the risk of offending any rabid Fox people out there, you should reconsider your front end...