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

2012-02-03

SELECT * FROM TB1 WHERE [C:\TB2.MDBPWD123].NOTB1.NOSELECT * FROM TB1 WHERE [C:\TB2.MDBPWD123].

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)