<select id="getBarcodeImports" resultType="cn.com.whbs.tmread.po.TmInfo">
SELECT T.*,SPMC ,g1.GGMC as gg1mc ,g2.GGMC as gg2mc ,rn=identity(int,1,1) into #temp
from WHBSMincoTMIPO t
left join SHANGPIN sp on sp.SPDM=t.spdm
left join GUIGE1 g1 on g1.GGDM=t.gg1dm
left join GUIGE2 g2 on g2.GGDM=t.gg2dm
where t.djbh=#{djbh}
select * from #temp
drop table #temp
</select>
sqlserver2000不支持row_number()函数写法
最新推荐文章于 2021-04-06 06:51:59 发布