表的互连 INNER JOIN

snowsky0497

在下表中  INNER 的作用
SELECT * FROM tb_Employees AS E INNER JOIN
     dbo.fn_EmployeesInDept(\'shipping\') AS EID
   ON E.EmployeeID = EID.EmployeeID

snowsky0497

在表连接中INNER 起的作用
望高手指点一下

leiaqua

按F1看帮助
SQL的帮助很详细的
inner join 就是内连接
等价于
select * from [表一]  as a, [表二]  as b where a.[字段名]=b.[字段名]