怎么在同个连接上建临时表，并更新以及查询

[zaite]

如以下原生语句： $sql = "select distinct bm,0 as j,0 as w,{$tmpfields} into #order_tmp1 from sn_order_pro,sn_order where sn_order.id=sn_order_pro.orderid and sn_order.consenddate>='$w-01-01' and sn_order.ddlx=1 and sn_order.state>3 order by bm asc"; $data = sqlsrv_query($conn, $sql); ............ ............ //写入临时表 //年度统计 $sql = "update #order_tmp1 set #order_tmp1.j=t1.num from #order_tmp1,(select bm,sum(pronumsort) as num from sn_order_pro,sn_order where sn_order.id=sn_order_pro.orderid and year(sn_order.consenddate)=".$j." and sn_order.xn=0 and sn_order.ddlx=1 and sn_order.state>3 group by bm) as t1 where #order_tmp1.bm=t1.bm"; sqlsrv_query($conn, $sql); ............ ............ //查询统计 $sql = "select #order_tmp1.bm,sn_pro.proname,sn_pro.cplx, #order_tmp1. from #order_tmp1 left join sn_pro on sn_pro.bm=#order_tmp1.bm"; $data = sqlsrv_query($conn, $sql);

使用think-orm的Db::execute、Db::query方法均会报：table doesn't exist