asp mssql复合查询

两个表：

表一名称：zhiwei

字段：
zhiweiid zhiweiname comid adddate



表二名称：company

字段：
comid companyname lock



要求：列出5条zhiwei表中最近添加的记录，该记录不得在表company中处于lock=1

注：我要列出最近5条招聘职位，但不显示已经处于锁定状态公司发布的职位。

SQL code

select top 5 * from zhiwei 
where not exists(select 1 from company where  lock=1 and comid=zhiwei.comid)
order by adddate desc

SQL code

select top 5* from zhiwei z inner join company c 
on z.comid = c.comid 
where lock != 1 
order by z.adddate desc;