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
简单的一个分页查询,报错,求解决
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
简单的一个分页查询,报错,求解决
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
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