我有以下MySQL查詢：SELECT p.*,
IF(COUNT(ms.PropertyID) > 0,1,0) AS Contacted,
pm.MediaID,
date_format(p.AvailableFrom, '%d %b %Y') AS 'AvailableFrom',
astext(pg.Geometry) AS GeometryFROM property p, propertygeometry pg
JOIN shortlist sl ON sl.PropertyID = p.id AND sl.MemberID = 384216
LEFT JOIN message ms ON ms.PropertyID = p.id AND ms.SenderID = 384216
LEFT JOIN property_media pm ON pm.PropertyID = p.id AND pm.IsPrimary = 1WHERE p.paused = 0
AND p.PropertyGeometryID = pg.idGROUP BY p.id我收到此錯(cuò)誤：＃1054-'on子句'中的未知列'p.id'據(jù)我所知，查詢看起來(lái)是正確的，知道發(fā)生什么了嗎？
ON子句中的MySQL未知列
臨摹微笑
2019-09-26 09:43:43
