SELECT COUNT(member_category.member_category_id) AS member_ct, type_category.category_nm, type_category.category_id
FROM (member INNER JOIN member_category ON member.member_id = member_category.member_id) INNER JOIN type_category ON member_category.category_id = type_category.category_id
Where member.show_yn = TRUE
GROUP BY type_category.category_nm, type_category.category_id
ORDER by type_category.category_nm
PBBA Member Directory by business category
Member Directory by Category
Click on a Category below to view Members by Category:
