我现在以一个表中"符合条件"的记录做成了一了视图,
要想把表中"不符合条件"的记录做成另一个视图,
请问用sql 语句怎么做?
---------------------------------------------------------------
create view viewname2 as
select * from table where not exists
(select * from viewname1 where id = table.id)
我现在以一个表中"符合条件"的记录做成了一了视图,
要想把表中"不符合条件"的记录做成另一个视图,
请问用sql 语句怎么做?
---------------------------------------------------------------
create view viewname2 as
select * from table where not exists
(select * from viewname1 where id = table.id)