if i understand this correctly
table:
gallerys
id|name|description
keywords
id|name
and then i have
table:
gallerys_keywords
id|gallery_id|keyword_id
SELECT g.name,g.description,
GROUP_CONCAT(gallerys_keywords.keyword_id SEPARATOR " ") AS keywordlist
FROM gallerys g
LEFT OUTER JOIN gallerys_keywords USING(gallery_id) GROUP BY g.id
unknown column gallery_id from where clause but its in gallerys_keywords?
or am I using LEFT OUTER JOIN table USING wrong?