[thelist] [sql] selecting multiple distinct columns

Paul Bennett paul at teltest.com
Tue Oct 28 22:06:37 CST 2003

I have a table with (among other things) 3 columns (int_area_1, 
int_area_2, int_area_3)

Is it possible to query the db to get the distinct values of  all these 
columns combined
(eg all the unique values from not just int_area_1, but from int_area_2 
and 3 as well)

I am envisioning I am going to have to do some kind of joiny thing but 
I'm not sure how....:)

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
or visit


More information about the thelist mailing list