C#技术百科
问问你的心你有没有信心 做事情要专一坚定,执着

select C_ID from (select top 100 percent  c_ID,CompanyName,(select count(*) from Product where C_ID=companyInfo.C_ID) SC from companyInfo
where C_ID not in(select min(C_ID) from companyInfo group by companyname )  order by len(C_ID) asc)  t where SC<1


 

posted on 2008-10-05 17:07  王德田  阅读(185)  评论(0编辑  收藏  举报