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