SELECT
mp.id,
mp.phone,
mp.carrier_id,
mp.region_id,
rg.name AS regionname,
ca.name AS carriername,
rg.area_identity AS areaidentity
FROM
gsms_region_carrier_map AS mp
JOIN gsms_carrier AS ca
ON mp.carrier_id = ca.id
JOIN gsms_region_code AS rg
ON mp.region_id = rg.id
WHERE mp.is_removed = FALSE
AND mp.id NOT IN
(SELECT
mp2.remove_id
FROM
gsms_region_carrier_map AS mp2
WHERE is_removed = TRUE)我想把后面的那个子查询变成 join 形式的.
ps:gsms_region_carrier_map 表id是主键.
mp.id,
mp.phone,
mp.carrier_id,
mp.region_id,
rg.name AS regionname,
ca.name AS carriername,
rg.area_identity AS areaidentity
FROM
gsms_region_carrier_map AS mp
JOIN gsms_carrier AS ca
ON mp.carrier_id = ca.id
JOIN gsms_region_code AS rg
ON mp.region_id = rg.id
WHERE mp.is_removed = FALSE
AND mp.id NOT IN
(SELECT
mp2.remove_id
FROM
gsms_region_carrier_map AS mp2
WHERE is_removed = TRUE)我想把后面的那个子查询变成 join 形式的.
ps:gsms_region_carrier_map 表id是主键.
解决方案 »
- MySQL Query 请教
- 我用ADO连接mysql 5.0,起初用ODBC3.51的驱动,连接正常,但是查询结果中文不显示;后用5.0的驱动,中文可以显示,但是连接速度极慢,请
- 把光盘中的数据库复制到MySql的按装目录/data之下,不好用
- 请教高手。备份问题。
- mysql(++) 菜鸟问题:
- mysql 的事务模式 如何使用 ???
- 请问group_concat怎么合并一样的内容
- 来个难度大点的,如何从csv更新“部分”数据到数据表?原数据表有内容
- 怎样实现图片上传到MySQL?
- mysql 下的存储过程 FETCH 赋值按照上面方式来赋值的
- 求mysql存储过程
- 用navicat连接mysql数据库出现问题
mp.id,
mp.phone,
mp.carrier_id,
mp.region_id,
rg.name AS regionname,
ca.name AS carriername,
rg.area_identity AS areaidentity
FROM
gsms_region_carrier_map AS mp
JOIN gsms_carrier AS ca
ON mp.carrier_id = ca.id
JOIN gsms_region_code AS rg
ON mp.region_id = rg.id
left join gsms_region_carrier_map mp2
on mp.id =mp2.remove_id
WHERE mp.is_removed = FALSE
AND mp2.remove_id is null