做连接*=问题

[weiweipxb]

SELECT * FROM (Select empno = employee_all.empno,
from rom_changeout_dbf with(nolock) ,
dbo.employee_all
WHERE rom_changeout_dbf.rno *= employee_all.rno )A WHERE A.empno = 'B00019'
我的empno是唯一的，这样执行出来的数据却是和没有加 WHERE A.empno = 'B00019'是一样的，改成left join 就成一条记录了。是不是*=不能用啊？？

[weiweipxb]

SELECT * FROM (Select empno = employee_all.empno,
from rom_changeout_dbf with(nolock) ,
dbo.employee_all
WHERE rom_changeout_dbf.rno *= employee_all.rno )A WHERE A.empno = 'B00019'
就是这个语句经常出现多条记录

[JonasFeng]

稍微修改了下，这样OK

SELECT E.* 
FROM rom_changeout_dbf R RIGHT JOIN   employee_all E 
     ON  R.rno = E.rno
WHERE E.empno = 'B00019'