Hello Michael

But that is a SELECT, not a VIEW.

I want to use parameters with CREATE VIEW.

Greetings.

On Wed, Mar 30, 2011 at 5:02 PM, Michael Ludwig <milu71@...> wrote:

>
>
> W O schrieb am 29.03.2011 um 14:29 (-0400):
>
> >
> > There is some way for use a view with distinct data?
> >
> > For example, to use the same view when the birthday's date is
> > '01.01.2001' or '29.03.2002'. Of course, birthday's date is a column
> > of the table.
>
> Just use a WHERE clause:
>
> SELECT NAME FROM V_PEOPLE WHERE BIRTHDAY = '29.03.2002';
> SELECT NAME FROM V_PEOPLE WHERE BIRTHDAY = '01.01.2001';
>
> --
> Michael Ludwig
>
>


[Non-text portions of this message have been removed]