SQL查询Inner Join 与 Left Join速度影响
原始语句select t_dealinfojg.*,cp.*,yl.* from t_dealinfojg left join (select * from t_dealinfocp,bs_comm as CpComm where dcp_ccid=CpComm.c_cid ) as Cp on di_cwd=dcp_cdiwd and di_ino=dcp_idino ,t_stockin
原创
2008-12-09 14:28:00 ·
4451 阅读 ·
0 评论