Using SELECT DISTINCT In CC so not to display duplicates

Hi All

I am using CC to manage an Artist database that lists both Artist Name and Song Titles

I am looking to use CC to List all the Artists in the table, but it lists the same artist for each song.

So as Bob would always say "Play around with Myphp Admin to get the desired result" and I have, I need to add

SELECT DISTINCT `Artist`

to the SQL Statement.

I have tried and tried but I cant seem to figure out how to include this, it wont work with the WHERE statement
Any help would really be appreciated

Hi darrenhallinan,

I don't think that there is any way of doing this with the standard ChronoConnectivity release. The hacked versions may support it OK. Otherwise you may be able to workaround using GROUP BY in the ORDER BY box - not ideal but can work.

Bob

Hi

Is there still no easy way to do this in Auto Listing?

Roger

Hi Roger,

Not that I know of, though Max may have some way of getting it to work.

Bob

Hi,

What about using "GROUP BY" instead ?

Regards,
Max

GROUP BY works fine in the WHERE SQL box.

Thanks,
Roger

Great news!🙂

Regards,
Max