[thelist] [sql] selecting multiple distinct columns
Paul Bennett
paul at teltest.com
Wed Oct 29 14:42:45 CST 2003
Paul Cowan wrote:
<snip>
>
>
> the UNION operator, by default, removes duplicates, so you'll just get
> out
> the distinct values. If you did want each value to appear multiple
> times as required, you'd use UNION ALL instead.
</snip>
This looked wonderful, until I found out that UNION was implemneted in
mysql 4+, and we are running 3.23.54
Gah!
I have asked for a db engine upgrade, so hopefully that will get this
working.
Thanks
:)
---------------------------------------
Paul Bennett
http://www.clicksave.co.nz
For your free report:
"10 time-killing web development mistakes and how to avoid them"
send an email to:
bennettpr at getresponse.com
More information about the thelist
mailing list