MySQL use inner join for query/delete/Modify Example

This article describes the use of inner join to query/delete/modify, the specific implementation of the following, learning MySQL friends can also learn, I hope to help you copy the code is as follows:
--Query
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 QD Gl_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;

Copy Code code as follows:
--Modify
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= ' 270108 25 ';

Copy Code code as follows:

--Delete
DELETE from JX_LSJL jx INNER JOIN isa_gtxx gt on jx.ckid=gt.gtbh WHERE gt.jgm= ' 27010825 ' and jx.jgm= ' 27010825 ';