SQLite Forum

SELECT question
Much appreciated. I was thinking a similar direction in that I knew I had to somehow combine the 2 queries. I tried your suggestions in various ways but did not get a reasonable answer. Sometimes no result at all.

I think it is the 'group by' that may be in the wrong place.