摘要： SELECT a.spid,z.max_date,a.kcshl FROM spkfjc a inner join (SELECT a.spid AS spid ,MAX(b.rq) AS max_date FROM spkfjc a JOIN splsk b ON a.spid=b.spid WH 阅读全文