[thelist] [sql] selecting multiple distinct columns

Paul Bennett paul at teltest.com
Wed Oct 29 14:42:45 CST 2003

Paul Cowan wrote:

> 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. 

This looked wonderful, until I found out that UNION was implemneted in 
mysql 4+, and we are running 3.23.54
I have asked for a db engine upgrade, so hopefully that will get this 


Paul Bennett
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