......
where isnull(bh_num,'test') not in -----为空 ?
(select cast(cp_tno as int) as bh_num
from print_Basic
where convert(char(7),cp_r_day,120) = '2005-04'
and cp_month_page = '0001')
where isnull(bh_num,'test') not in -----为空 ?
(select cast(cp_tno as int) as bh_num
from print_Basic
where convert(char(7),cp_r_day,120) = '2005-04'
and cp_month_page = '0001')
你看看这个!!!
WHERE bh_num not in ( select cp_tno from print_Basic
WHERE convert(char(7) , cp_r_day , 120) = '2005-04'
AND cp_month_page = '0001' )