Subject Re: complex select
Author duilio_fos <>

> You could change to explicit join syntax, and qualify the field
name in the GROUP BY

I am afraid I don't understand: could you expand on this ?

I need a way to better code readability and make testing easier: how
does your suggestion fulfill these goals ?

During the night, it came to my mind I could use views, that I keep
overlooking and are a powerful tools, instead.

One could create VIEW1 with CONDITION1 in the WHERE clause, then
create VIEW2 by appliying CONDITION2 to VIEW2, etc.

Not exactly what I was looking for, but if there is no other way...

Thank you