[ad_1]
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
[ad_2]
solved SQL Select Statement joining [duplicate]
[ad_1]
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
[ad_2]
solved SQL Select Statement joining [duplicate]