聚合函数 on 内部的not in

[xxczyc]

select top 6 a.name,b.typename from
glass a left join glasstype b
on(a.typecode=b.selfcode and a.gid not in (select top 6 gid from glass))
group by a.name,b.typename a.typecode,b.selfcode,a.theindex

简单的一个分页查询，报错，求解决

[still_melody]

select top 6 a.name,b.typename fromglass a left join glasstype b on a.typecode=b.selfcode where a.gid not in (select top 6 gid from glass) group by a.name,b.typename a.typecode,b.selfcode,a.theindex

[gxingmin]

select top 6 a.name,b.typename 
from glass a left join glasstype b
on a.typecode = b.selfcode 
where a.gid not in (select top 6 gid from glass)
group by a.name,b.typename, a.typecode,b.selfcode,a.theindex

[快溜]

select top 6 a.name,b.typename from glass a left join glasstype b on a.typecode=b.selfcode where a.gid not in (select top 6 gid from glass) group by a.name,b.typename a.typecode,b.selfcode,a.theindex

[迪卡]

select top 6 a.name,b.typename from glass a left join glasstype bon a.typecode = b.selfcode where a.gid not in (select top 6 gid from glass)group by a.name,b.typename, a.typecode,b.selfcode,a.theindex

on 是 join的 条件，where 是 select 的条件，得分开写。