in能用多个字段去关联子查询吗解决办法

in能用多个字段去关联子查询吗
错误：

SQL code

select policyno,itemkindno from tmp_policy_prp where(policyno,itemkindno)  not in (select policyno,itemkindno  from tmp_policy_stat)

SQL code

select policyno,itemkindno from tmp_policy_prp t1 where not exists(select 1  from tmp_policy_stat t2where t1.policyno=t2.policynoand t1.itemkindno=t2.itemkindno)