[thelist] [sql] selecting multiple distinct columns

[Ken Schaefer]

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
etc?

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

Cheers
Ken

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