adding "all' in a view

[nikol]

Hi,
I have table with a column which has shows all cities in CA state. Is it possible to add one more row "all cities" in a view.I cant add anything in DB tables. So,I was just wondering can I make a view of all CA state cities & add one more row "all cities" which means all cities in CA.

 

[amrita418]

Try something like this:

select cityname cities from TableA
union all
select 'all cities' cities from TableA

Regards,
AA

 

[mrdenny]

Or better yet something like this.

selcet Cityname cities from tablea
union all
select 'All Cities'

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)