I have a 2 tables that i need information from:
1. Categories (hierarchy (nested set model)): id, name, lft, rgt
2. Items: id, categoryID, name
I need a query that receives all the items from the selected category (incl sub-categories)
This has to be a join query.
Thanks in advance!