select bmnr
from tbl_xtbm
while tbl_xtbm.bmh=tbl_bb_sc_dldfjcb.sh and tbl_bb_sc_dldfjcb.sh='29' ;
为什么会提示SQl语句未能正确结束?我初学,别打击我,帮忙,谢了!!
from tbl_xtbm
while tbl_xtbm.bmh=tbl_bb_sc_dldfjcb.sh and tbl_bb_sc_dldfjcb.sh='29' ;
为什么会提示SQl语句未能正确结束?我初学,别打击我,帮忙,谢了!!
select ta.bmnr
from tbl_xtbm ta,tbl_bb_sc_dldfjcb tb
where ta.bmh=tb.sh --是where 不是while
and tb.sh='29' ;