"All" option to drop down using single select qry

[snehalata_d]

Hi,

I am trying to create input control using single select query.I want to add "All"

option along with other options that I derive from database's table.

I have given Value column and Visible columns as shipcountry.The query that I am

using is "select distinct shipcountry from orders order by shipcountry"

What should I do to add "All" to the drop down list using single select query?

Please help.

Regards,

Snehalata
 

[snehalata_d]

Hi All,

My problem has been solved.

I just changed my query to "select distinct shipcountry from orders  UNION select 'All' from orders order by 1 ".

Regards,

Snehalata