mysql - 'on clause' 中的未知列

Question

我有这个 MySQL 查询，它一直在正确选择数据，直到我加入另一个表 (afk_measures_childs) 并给我这个错误:"#1054 - 'on 子句' 中的未知列 'md.org_date' "

select md.id,md.value,md.text_ar,md.photo,md.created_date org_date,mc.ar_title from afk_map_data md,afk_measures_childs mc
INNER JOIN 
(SELECT id,max(created_date) max_date from afk_map_data) t 
on 
t.max_date = md.org_date
WHERE
md.measures_child_id = mc.id
AND
md.map_id = 1
AND
md.state_id = 1
AND
md.measures_id= 1 
order by md.id

任何帮助将不胜感激

Answer 1

不要混合使用旧的隐式连接语法和新的显式连接语法。

select md.id,md.value,md.text_ar,md.photo,md.created_date org_date,mc.ar_title 
from afk_map_data md
JOIN afk_measures_childs mc on md.measures_child_id = mc.id
JOIN 
(
   SELECT id, max(created_date) max_date 
   from afk_map_data
) t on t.max_date = md.org_date
WHERE md.map_id = 1
AND md.state_id = 1
AND md.measures_id= 1 
order by md.id