语句如下:select a.spid,a.spbh,a.spmch,b.hwshl,b.hw into #t15 from spkfk a left join hwsp b on a.spid=b.spidselect a.spbh,b.spmch,b.hwshl from cb0915 a left join #t15 b
on a.spbh=b.spbh and b.hw='HWI00000005' order by a.spbh desc
drop table #t15
因为hw不止一个,我不想每次都要粘贴一次hw,我想一次过显示所有hw的hwshl,如下所示:
spbh spmch hw1 hw2 hw3
2109011 fghgf 46 31 232
2109005 jhghg 12 21 21
2104363 fdg 22 21 212
2104362 dfg 12 212 212
2104361 cv 121 51 21请各位高手帮帮忙!
on a.spbh=b.spbh and b.hw='HWI00000005' order by a.spbh desc
drop table #t15
因为hw不止一个,我不想每次都要粘贴一次hw,我想一次过显示所有hw的hwshl,如下所示:
spbh spmch hw1 hw2 hw3
2109011 fghgf 46 31 232
2109005 jhghg 12 21 21
2104363 fdg 22 21 212
2104362 dfg 12 212 212
2104361 cv 121 51 21请各位高手帮帮忙!
上面这样我没运行一次之后都要重新粘贴 b.hw='HWI00000005' 中的HWI00000005才能查下一个hw。我想直接运行一次就得出所欲hw的hwshl。如下:
spbh spmch hw1 hw2 hw3
2109011 fghgf 46 31 232
2109005 jhghg 12 21 21
2104363 fdg 22 21 212
2104362 dfg 12 212 212
2104361 cv 121 51 21