Does anyone know the SQL statement to select all LINKS records under a specific category tree branch?
For example, given the following category tree:
A
----B
---------BA
---------BB
--------------------BBA
--------------------BBB
C
D
I need to find all Links under the "B" Branch, i.e. ALL LINKS IN THE FOLLOWING CATEGORIES: B, BA, BB, BBA, BBB
A comprehensive ERM diagram would also help...
For example, given the following category tree:
A
----B
---------BA
---------BB
--------------------BBA
--------------------BBB
C
D
I need to find all Links under the "B" Branch, i.e. ALL LINKS IN THE FOLLOWING CATEGORIES: B, BA, BB, BBA, BBB
A comprehensive ERM diagram would also help...