To 楼上两位: 通过SQL语句执行是可以创建视图的,但是我要创建的视图中包括有联合,例如在ACCESS中的视图中显示的语句为: select aa from client union select bb from user那么我如何用Create view 呢? 用 Create view as select aa from client union select bb from user 报错——》子查询不许联合。
不是好像,是真的,你看看ACCESS的帮助,有视图的概念吗?反正我是没找到
可以通过Create View 用ADOQuery创建的,只是当象我上面所创建的视图含有 Union 时就提示不行。有好的办法吗?
在Access程序中,通过手动创建这样一个联合查询/视图 select id, name from t_user UNION ALL select id, name from t_user2; 是可以的,但是如何用sql语句来创建我没有测试过,方法肯定是有的,呵呵 ______________http://hthunter.vicp.net/
To hunterht(核桃——俺就是核桃的马甲):在Access程序中,通过手动创建这样一个联合查询/视图 select id, name from t_user UNION ALL select id, name from t_user2; 是可以的,但是用sql语句来创建时,却提示错误,如何解决??
用access还要建试图阿 要求抬高了
create view [视图名] as select * from [表名] [where 条件]
如果要联合的话为:create view [视图名] as select * from (select * from [表1] [where 条件] union select * from [表2] [where 条件]) as ok
在数据连接如:adoconnection.Execute('create view [视图名] as select * from (select * from [表1] [where 条件] union select * from [表2] [where 条件]) as ok ')试试
通过SQL语句执行是可以创建视图的,但是我要创建的视图中包括有联合,例如在ACCESS中的视图中显示的语句为:
select aa from client
union
select bb from user那么我如何用Create view 呢?
用 Create view as select aa from client
union
select bb from user
报错——》子查询不许联合。
select id, name
from t_user
UNION ALL select id, name
from t_user2;
是可以的,但是如何用sql语句来创建我没有测试过,方法肯定是有的,呵呵 ______________http://hthunter.vicp.net/
select id, name
from t_user
UNION ALL select id, name
from t_user2;
是可以的,但是用sql语句来创建时,却提示错误,如何解决??
要求抬高了
select * from (select * from [表1] [where 条件] union select * from [表2] [where 条件]) as ok
select * from (select * from [表1] [where 条件] union select * from [表2] [where 条件]) as ok
')试试