Im trying to make "Categories" only show ones that have atleast 1 "Posts" assigned to them. In other words, it won't list a Category if it is empty.
My problem is I have two tables. I have this totally wrong, can anyone give me some advice?
categories AS c
posts as p
COUNT(p.assign_category) > 1