h*********o
发帖数: 151 | 1 现有这样一段code，目的是：display the names of all navigators who are also
managers.
proc sql;
select lastname,firstname
from sasuser.staffmaster
where 'NA'=
(select jobcategory
from sasuser.supervisors
where staffmaster.empid = supervisors.empid);
我不明白的是 where clause里面的 'NA'= 是什么意思啊？作什么用的呢？为什么不写
成这样呢：
proc sql;
select lastname,firstname
from sasuser.staffmaster
where staffmaster.empid in
(select supervisors.empid
from sasuser.supervisors); |
|
