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'
就是这个语句经常出现多条记录
from rom_changeout_dbf with(nolock) ,
dbo.employee_all
WHERE rom_changeout_dbf.rno *= employee_all.rno )A WHERE A.empno = 'B00019'
就是这个语句经常出现多条记录
FROM rom_changeout_dbf R RIGHT JOIN employee_all E
ON R.rno = E.rno
WHERE E.empno = 'B00019'