MYSQL使用inner join 进行 查询/删除/修改示例

--查询
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' ;