I am doing a multi table view on two tables that have a one to many
relationship. I want to retrieve only records from the parent table that
have greater than a certain amount of records in the child table.
For example: I want to see from my "Clients" table only those clients who
have more than 50 invoices in my "Invoice" table and are in the state of
Arkansas.
I have experimented with SQL statements with no success. Any suggestions
will be very much appreciated. Thanks.