I have two table Table Category (Cate_id, Parent_id)
Cate_id | Parent_ID
1 | 0
3 | 1
2 | 0
4 | 1
And table Products (Product_id, Category_id)
Product_id | Category_id
1 | 1,3
2 | 4
How to select product ID with category_id = 1 and category have parent = 1?
Aucun commentaire:
Enregistrer un commentaire