select TitleID,TitleName from tta_title where TitleID not in (select TitleID from tta_EmpManagetitleID where empsso ='999324' union select '0' as TitleID) order by TitleName
select TitleID,TitleName from tta_title where TitleID not in (select TitleID from tta_EmpManagetitleID where empsso ='999324') and TitleID <> '0' order by TitleName;
如果TitleID是char或者varchar2类型的话就, union select '0' from dual 如果是int型的,就把那段改成 union select 0 from dual
select TitleID,TitleName from tta_title where trim(TitleID) not in (select TitleID from tta_EmpManagetitleID where empsso ='999324') and TitleID <> '0' order by TitleName;
select '0' as TitleID有问题,这是SQL Server的写法,Oracle中应该是 select '0' as TitleID from dual
where TitleID not in (select TitleID from tta_EmpManagetitleID where empsso ='999324')
and TitleID <> '0'
order by TitleName;
union select '0' from dual
如果是int型的,就把那段改成
union select 0 from dual
where trim(TitleID) not in (select TitleID from tta_EmpManagetitleID where empsso ='999324')
and TitleID <> '0'
order by TitleName;
select '0' as TitleID from dual