Is is possible to add column in a view if yes then how?
pl help me?

rekha

__________________
It is always safe to assume, not that the old way is wrong, but that there may be a better way...
*************************
Rekha

A view is nothing more than a stored query. To add a column, you need to modify the stored query underlying the view to add another column to the SELECT list.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC