摘要：
SELECT * FROM MainTable mLEFT JOIN (SELECT d.* FROM (SELECT MAX(clc.Id) AS id FROM ChildTable AS clc GROUP BY clc.ParentId) t LEFT JOIN ChildTable AS 阅读全文
posted @ 2018-03-06 09:57 冰碟 阅读(980) 评论(0) 推荐(0)
|
|||
|
摘要：
SELECT * FROM MainTable mLEFT JOIN (SELECT d.* FROM (SELECT MAX(clc.Id) AS id FROM ChildTable AS clc GROUP BY clc.ParentId) t LEFT JOIN ChildTable AS 阅读全文
posted @ 2018-03-06 09:57 冰碟 阅读(980) 评论(0) 推荐(0) |
|||
浙公网安备 33010602011771号