sql语句做视图

我现在以一个表中"符合条件"的记录做成了一了视图,
要想把表中"不符合条件"的记录做成另一个视图,
请问用sql 语句怎么做?
---------------------------------------------------------------

create view viewname2 as
select * from table where not exists
(select * from viewname1 where id = table.id)

Published At
Categories with 数据库类
comments powered by Disqus