Sorry, no data has found.select middle,ccde2,CCDJ2,IsNull((select top 1 thumbnailImage from class where large = '016' and middle = s.middle), '') as thumbnailImage,IsNull((select top 1 standardImage from class where large = '016' and middle = s.middle), '') as standardImage,[6count],CCDJ1 from (select distinct middle,ccde2,CCDJ2, [6count],CCDJ1 from Class where large ='016' and [6count] > 0 and (ccdj3 is null or ccdj3 = N'一般') and ccdj2 != '#N/A') s order by CCDJ2Sorry, no data has found.select distinct Mname.manufacturer as manufacturerName, Mno.manufacturer from manufacturer Mname inner join classcode_match_manufacturer Mno on Mname.mfgno = Mno.manufacturer where left(Mno.classcode,3) ='016' and Mno.manufacturer <> '' and Mname.manufacturer is not null order by Mname.manufacturer