Re: Проблема со view's

[Alex Karp]

> select Up.test_field1
>  from User_param2 UP
>  where
>  UP.test_field1 not in
>   (
>    select U.test_field1
>     from User_param2 U
> where U.test_field1 = 'system1'
>   )
>

CREATE VIEW TEST_VIEW(
    ID)
AS
select Up.test_field1
 from User_param2 UP
 where
 not exists (select *
               from User_param2 U
               where U.test_field1 = 'system1')
;

-- 
WBR Alex Karpeykin