schmii <schmi...@gmail.com>

I’ve found many of my tables are structured in pairs consisting of a
primary_table whose entries are classified against a corresponding
table of table_types.
I have structured table_type to be hierarchically with a self-
referential parent_id so that the top is ALL (0), whose children form
the second level are GROUPS under which all categories are referenced.
For example if I have a table of contacts who are grouped as, TRADES,
SERVICES, APARTMENT, etc..
Then the children under APARTMENT may be ‘tenants’, ‘owners’,
‘managers’, ‘operators’ etc..

Is there a dynamic way to list the entries of the primary_table with
respect to ‘ALL’ or any of their associated ‘GROUPs’?

Thanks inadvance
schmii