mysql - Query using two tables with DISTINCT -
i have 2 tables - clients , - group
i need county , zip clients , group-assigned group
when search, cannot distinct results, is, instead of output showing 100 clients zipcode 12345 in jones county in main st group.
i need have each zip , county listed 1 time group. have googled , attempted many ways beyond me.
can assist in steering me right way
adding group group, city, zip end of query should need. homecoming unique combinations of three.
mysql
No comments:
Post a Comment