[Solved] SQL Select Statement joining [duplicate]
Use Join SELECT ocd.category_id, image, parent_id, name FROM oc_category_description AS ocd INNER JOIN oc_category WHERE parent_id = 0 ORDER BY ocd.category_id ASC 2 solved SQL Select Statement joining [duplicate]