吃完饭回来发现还没结贴啊。。。


select *
from data b
left join (select distinct COMPANY from data where YEAR like '%2006%') a on b.company=a.company
where
b.YEAR like '%2005%'
and a.company is null