[eluser]Bigil Michael[/eluser]
is it possible to select distinct values from three columns of same table
Code:
table name tour_package
columns id tour_type1 tour_type2 tour_type3
1 pilgrim tour leisure tour Beach Holidays
2 Hiking Holidays Hiking Holidays Adventure Tours
i want the result like this
pilgrim tour
leisure tour
Beach Holidays
Hiking Holidays
Adventure Tours
i want the result in a single query, is it possible???????
can any one help me??
thanks in advance...