22,209
社区成员
发帖
与我相关
我的任务
分享
select * from 基本信息表1 left join
(select t3.* from 基本沟通表1 t3 inner join (select Max(Gid) as gid1,QID from 基本沟通表1 group by 基本沟通表1.Qid) t4
on t3.gid=t4.gid1 and t3.qid=t4.qid) t2
on 基本信息表1.id =t2.Qid
where 1=1 and t2.求职状态='情况不明'
select * from 基本信息表1 left join
(select t3.* from 基本沟通表1 t3 inner join (select Max(Gid),QID from 基本沟通表1 group by 基本沟通表1.Qid) t4
on t3.gid=t4.gid and t3.qid=t4.qid) t2
on 基本信息表1.id =t2.Qid
where 1=1 and t2.求职状态='情况不明'
SELECT *
FROM 基本信息表1
LEFT JOIN ( SELECT *
FROM 基本沟通表1
WHERE Gid IN ( SELECT MAX(Gid)
FROM 基本沟通表1
GROUP BY 基本沟通表1.Qid )
) AS t2 ON 基本信息表1.id = t2.Qid
WHERE 1 = 1
AND t2.求职状态 = '情况不明'
把基本信息表1.id 和t2.Qid,t2.求职状态都加索引,然后left join里面的select * 改成qid