Ошибка mysql “Unknown column 'subcategories_category' in 'on clause'”

147

27 декабря 2019, 13:00

Запрос выдает ошибку.

Unknown column 'subcategories_category' in 'on clause'.

Помогите найти ошибку.

Вот сам запрос:

SELECT categories.id as categories_id, 
       categories.category as categories_category,  
       subcategories.id as subcategories_id, 
       subcategories.subcategory as subcategories_subcategory, 
       subcategories.category as subcategories_category 
FROM subcategories 
LEFT JOIN categories ON subcategories_category = categories_id

Answer 1

SELECT 
    c.id AS categories_id,
    c.category AS categories_category,
    sc.id AS subcategories_id, 
    sc.subcategory AS subcategories_subcategory,
    sc.category AS subcategories_category
FROM subcategories sc
LEFT JOIN categories c ON c.id = sc.category