You probably need to use GROUP BY instead of DISTINCT in this case.
Post your query now and I will help you more.
Alternatively, if you just want to return the first address, that's a different query entirely. Does it need to return the address? What data do you need…
Top comments (0)