Posted by Hugo Kornelis on 11/23/05 01:25

On Tue, 22 Nov 2005 20:02:03 GMT, Will Chamberlain wrote:

(snip)
>SELECT Max(COALESCE(Sheet.Ver, 'NONE')) AS MaxOfVer,
>Max(COALESCE(Update.Update, 0)) AS MaxOfUpdate, Sheet.SheetNumber FROM
(snip)

Hi Will,

Following on to Erlands remakrs, I think you should change this part to

SELECT COALESCE(MAX(Sheet.Ver), 'NONE') AS MaxOfVer,
COALESCE(MAX(Update.Update), 0) AS MaxOfUpdate,
Sheet.SheetNumber
FROM ....

That way, the MAX of all values will be used, or NONE / 0 if there were
no values at all in the set.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[Back to original message]