[thelist] [sql] selecting multiple distinct columns

Ken Schaefer ken at adOpenStatic.com
Tue Oct 28 23:30:36 CST 2003

Can you elaborate on exactly what you want to do? Do you want to combine all
columns, and get the distinct resultant values? Do you want to get a list of
distinct values for column1, and then a distinct list of values for column2

Perhaps post some dummy data, and expected output, and we can help.


From: "Paul Bennett" <paul at teltest.com>
Subject: [thelist] [sql] selecting multiple distinct columns

: '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)
: ?

More information about the thelist mailing list