--查詢 SELECT tp.tp_id, tp.tpmc, tp.leveid, tp.tpdz, tp.jgm, tp.scsj, tp.pbzyid, tp.ksbfsj, tp.jsbfsj, tp.status, tp.tpbz FROM qdgl_tupian tp INNER JOIN qdgl_pqb pq ON tp.tp_id=pq.tpid WHERE pq.bfjgm='27010825' AND ps_bfsj >= '2013-01' AND ps_bfsj< 2013-05-31 ;
復制代碼 代碼如下:
-- 修改 UPDATE jx_lsjl jx INNER JOIN isa_gtxx gt ON jx.ckid=gt.gtbh set jx.ckid=gt.gtid WHERE gt.jgm='27010825' AND jx.jgm='27010825' ;
復制代碼 代碼如下:
--刪除 DELETE FROM jx_lsjl jx INNER JOIN isa_gtxx gt ON jx.ckid=gt.gtbh WHERE gt.jgm='27010825' AND jx.jgm='27010825' ;
您可能感興趣的文章:
MySQL的子查詢中FROM和EXISTS子句的使用教程MySQL查詢優化:連接查詢排序limit(join、order by、limit語句)介紹MySQL優化之使用連接(join)代替子查詢MySQL利用profile分析慢sql詳解（group left join效率高于子查詢）mysql多個left join連接查詢用法分析mysql使用from與join兩表查詢的區別總結
