Luis Sousa writes:
> I have a query that joins several table with some restrictions.
> I want to take out those restrictions from the query and create a view
> that does not show the fields that are used to restrict the data, but in
> some way, i can restrict that data when i call the view.
Do you mean like this?
create table A (id int, content text);
create table B (id int, stuff numeric);
create view C as select A.content, B.stuff from A, B where A.id = B.id;
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter