56,678
社区成员
发帖
与我相关
我的任务
分享
SELECT e.plc_text, e.pl_id FROM
( SELECT pal.pl_id, plc.plc_text, plc.plc_time
FROM dreye_uw.pay_license pal LEFT JOIN dreye_uw.pay_license_content plc
ON plc.plc_license_id = pal.pl_id
WHERE plc.plc_state = 'product'
ORDER BY plc.plc_time DESC
) AS e
GROUP BY e.pl_id
update pay_license plce inner join (
SELECT e.plc_text, e.pl_id FROM
( SELECT pal.pl_id, plc.plc_text, plc.plc_time
FROM dreye_uw.pay_license pal LEFT JOIN dreye_uw.pay_license_content plc
ON plc.plc_license_id = pal.pl_id
WHERE plc.plc_state = 'product'
ORDER BY plc.plc_time DESC
) AS e
GROUP BY e.pl_id
) w on plce.pl_id = w.pl_id
set plce.plc_text=w.plc_text