Example: I have a table containing 2 columns called AVERAGE and AVERAGENETTO.
I want to have an AVG on my AVERAGE column, but in case on a row the AVERAGENETTO is larger then the AVERAGE field, then the AVERAGENETTO should be used.
How do I create such a query ?
Any help appreciated.