[thelist] [sql] selecting multiple distinct columns
Paul Bennett
paul at teltest.com
Tue Oct 28 22:06:37 CST 2003
'ello
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
http://www.clicksave.co.nz
More information about the thelist
mailing list