Re: How to join table with the distinct value from another table

[Peter Brawley]

> join from a cases_counsel table on the "first" unique value

First on what ordering?

Let's see the results of ...

Show Create Table cp_counsel;
Show Create Table cp_cases;