A key thing to notice here is the existence of a DEPTID column in both tables.
这里需要重点注意的是,在both表中有一个deptid列。
Using JoinRowSet lingo, our JOIN operation was performed using a match column of DEPTID.
在使用JoinRowSet lingo时,JOIN操作是通过匹配列deptid来执行的。
Query 19 returns the deptID of those departments which have a unit manager among their employees.
查询 18 返回其员工中包含单位主管的那些部门的 deptID。
应用推荐