SELECT * FROM TB1 WHERE [C:\TB2.MDB;PWD=123].NO=TB1.NO解决方案

SELECT * FROM TB1 WHERE [C:\TB2.MDB;PWD=123].NO=TB1.NO
SELECT * FROM TB1 WHERE [C:\TB2.MDB;PWD=123].NO=TB1.NO
上面这条查询语句有误，如果要实现这个功能，如何修改？

[解决办法]
SELECT a.* 
FROM TB1 a,[C:\TB2.MDB;PWD=123].TB2 b 
WHERE a.DF1=b.FD2

OR

SELECT * 
FROM TB1
WHERE DF1 IN (SELECT FD2 FROM [C:\TB2.MDB;PWD=123].TB2)