huawei--创建视图,用到union和union all
<br />CREATE OR REPLACE VIEW vwAgentInfo as select * from tAgentInfo<br />where (SubCCNo,VDN) =(select SubCCNO,VDN from tUserInfo where Username=user) with read only<br />/<br />CREATE OR REPLACE VIEW vwRecordInfo as<br />select * from tRecordInfo1 where (
原创
2010-12-01 20:44:00 ·
5143 阅读 ·
0 评论