create view V_tableTemp as select a.* from TEMPCLIENT a ,TEMPCLIENTSTUFF b where a.CORNO<>'' and a.CORNO = b.CORNO
select * from V_tableTemp
sqlserver 中创建表按照视图结构，并插入数据。相当于 oracle 中 create table tableTemp as V_tableTemp
SELECT * INTO tableB from V_tableTemp
