帮我解释下这个查询语句@
帮我解释下这个查询语句@
select c_id,c_gcode,c_number into #11 from tb_bill_rg where c_id in(select c_id from tb_bill_r where datediff(day,c_au_time,'2007-04-01')=0 and c_ad_from like '2%') and c_gcode not in(select c_gcode from tb_d_sum_gds
where c_number_move>0 and datediff(day,c_dt,'2007-04-01')=0 and c_adno like '2%')
order by c_gcode
select #11.c_id,#11.c_gcode,#11.c_number,tb_gds.c_name from #11,tb_gds where #11.c_gcode=tb_gds.c_gcode
order by #11.c_gcode
有很多地方不明白,请逐步细致的帮我解释哈
特别像#11,这个代表什么?
select c_id,c_gcode,c_number into #11 from tb_bill_rg where c_id in(select c_id from tb_bill_r where datediff(day,c_au_time,'2007-04-01')=0 and c_ad_from like '2%') and c_gcode not in(select c_gcode from tb_d_sum_gds
where c_number_move>0 and datediff(day,c_dt,'2007-04-01')=0 and c_adno like '2%')
order by c_gcode
select #11.c_id,#11.c_gcode,#11.c_number,tb_gds.c_name from #11,tb_gds where #11.c_gcode=tb_gds.c_gcode
order by #11.c_gcode
有很多地方不明白,请逐步细致的帮我解释哈
特别像#11,这个代表什么?
英语人气:572 ℃时间:2020-03-28 14:54:24
优质解答
select c_id,c_gcode,c_number into #11 from tb_bill_rg 的意思是:在tb_bill_rg 表中查询c_id,c_gcode,c_number字段写入#11表中相应字段.where c_id in(select c_id from tb_bill_r where datediff(day,c_au_time,...
我来回答
类似推荐
猜你喜欢
- 1绿野仙踪的英文读后感
- 2填动词:I like ice cream.He _______ice cream .He used to ________coffee.
- 3英语翻译
- 4how did you come up with the idea?---------loking through some magazines
- 5如果把顺时针方向旋转一周记作+360度,那么-90度表示
- 6已知九个连续偶数,其中最大数是最小数的9倍,则这九个数是 _ .
- 7教学大楼用英语怎么说
- 8作文经典好词好句好段摘抄大全
- 9在abc中,∠A=50度,∠B=∠C,点D,E,F分别在的,AB,BC,AC,上,BD=CE,BE=CF,求∠DEF
- 10How drills wooden to make a fire?