Abfrage:

SELECT  c.title AS title
            , c.introtext AS body
            , c.state AS state
            , c.created AS created
            , c.created_by AS uid
            , c.modified AS modified
            , c.modified_by AS modified_uid
            , c.published AS published
            , c.published_by AS published_uid
            , jos_categories.title AS category
FROM
          jos_content AS c, jos_categories
INNER JOIN jos_categories AS jc
ON c.sectionid = jc.section
WHERE c.sectionid = 7

Ich bin mir sicher, dass die sectionid-Spalte existiert, aber ich erhalte die Fehlermeldung:

Fehlercode: 1054. Unbekannte Spalte 'c.sectionid' in 'on-Klausel' 0,000 Sek

Ich habe dieses Thema gesehen:Unbekannte MySQL-Spalte in der ON-Klausel aber ich kann es auch nicht lösen.