Subject | Re: complex select |
---|---|
Author | duilio_fos <irel_llc@libero.it> |
Post date | 2003-02-16T08:44:48Z |
Aage,
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
Duilio
> You could change to explicit join syntax, and qualify the fieldname 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
Duilio