MySQl查询问题

Question

我没有花很多时间在MySQL，但我被要求调查我的教会网站的问题。它已经下降了相当一段时间，我正在努力使它恢复和运行。最初的网站是在Mambo 4.5.3中完成的，这是一个旧版本。我会在某个时候对它进行升级，但我只想让它暂时运行。

我目前有一个问题，与Mambo内置的查询下面。无论网站管理部门试图访问页面的何处，我都会收到错误消息：

“on子句”中未知列'c.access‘。

我已经验证了列确实存在于指定的表中。现在我很困惑。我打开了MySQL查询分析器并将查询粘贴进来，并得到了与代码1054相同的错误消息。有人有什么想法吗？

SELECT 
    c.*, 
    g.name AS groupname, 
    cc.name, 
    u.name AS editor, 
    f.content_id AS frontpage, 
    s.title AS section_name, 
    v.name AS author 
FROM 
    mos_content AS c, 
    mos_categories AS cc, 
    mos_sections AS s 
    LEFT JOIN mos_groups AS g ON g.id = c.access 
    LEFT JOIN mos_users AS u ON u.id = c.checked_out 
    LEFT JOIN mos_users AS v ON v.id = c.created_by 
    LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id 
WHERE 
    c.state >= 0 
    AND c.catid=cc.id 
    AND cc.section=s.id 
    AND s.scope='content' 
ORDER BY 
    s.title, 
    c.catid, 
    cc.ordering, 
    cc.title, 
    c.ordering 
LIMIT 
    0,10

Answer 1

SELECT  
    c.*,  
    g.name AS groupname,  
    cc.name,  
    u.name AS editor,  
    f.content_id AS frontpage,  
    s.title AS section_name,  
    v.name AS author  
FROM  
    mos_content AS c 
    INNER JOIN mos_categories AS cc on c.catid=cc.id  
    INNER JOIN mos_sections AS s on cc.section=s.id 
    LEFT JOIN mos_groups AS g ON g.id = c.access  
    LEFT JOIN mos_users AS u ON u.id = c.checked_out  
    LEFT JOIN mos_users AS v ON v.id = c.created_by  
    LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id  
WHERE  
    c.state >= 0  
    AND s.scope='content'  
ORDER BY  
    s.title,  
    c.catid,  
    cc.ordering,  
    cc.title,  
    c.ordering  
LIMIT  
    0,10 

Answer 2

误差1052消息文本实际上类似于Column 'foo' in %s is ambiguous。通常情况下，当您连接具有同名列的表时，并且引用它们时没有表前缀。

*-？