Please Ignore my previous post.

Doh! Doh! Doh!

It seems unlikely that everyone is wrong.

Even unlikelier that I am right! but -

SELECT COL1,COL2,COL3 FROM TABLE1 GROUP BY COL1

works!

However,

SELECT COL2,COL3 FROM TABLE1 GROUP BY COL1

does NOT work.

So doesn't...