I have 2 tables and I fetch the values of both in a view
The tables are the cities and the forecast for each cities (many to many relation).
I want to ask if a there is way to add at the view a distinct number for each "record" of the view .
Something like that (I do not need the groub by)

the GROUP BY is what makes it work