[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