由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - newbie Q: how to "create view" in ACCESS
相关主题
How to get SQL help in sqlplus?SQL Server stupid questions
help needed on aspx&ms-accessHelp for VB 6 and MS Access DB
change year format in Access by SQL query (转载)Oracle 有这种 create partially sorted index方法吗?
error of sql query in MS Access database (转载)~{8_JVGsVz~}: how to create trigger on a nested table?
Help!any informix high hand here? sql need help here.
Can I create thousands table in one...oracle 8i "case when" syntax
[转载] question about SQL in Accessa pro*c++ Q
Access database 求助问个查询的问题
相关话题的讨论汇总
话题: create话题: access话题: view
进入Database版参与讨论
1 (共1页)
r****y
发帖数: 26819
1
I tried:
CREATE VIEW idview1 AS
SELECT id1, id2
FROM try
WHERE id1=1;
but got error: SYNTAX ERROR IN CREATE TABLE STATEMENT.
Thanks!
s****n
发帖数: 80
2
it's called query. you can build in a GUI.

【在 r****y 的大作中提到】
: I tried:
: CREATE VIEW idview1 AS
: SELECT id1, id2
: FROM try
: WHERE id1=1;
: but got error: SYNTAX ERROR IN CREATE TABLE STATEMENT.
: Thanks!

1 (共1页)
进入Database版参与讨论
相关主题
问个查询的问题Help!
如何在oci中运行sql script?Can I create thousands table in one...
再请教一个问题:stored procedure能不能直接显示信息什么的? (转载)[转载] question about SQL in Access
谁知道删除表以后,如何释放硬盘空间?Access database 求助
How to get SQL help in sqlplus?SQL Server stupid questions
help needed on aspx&ms-accessHelp for VB 6 and MS Access DB
change year format in Access by SQL query (转载)Oracle 有这种 create partially sorted index方法吗?
error of sql query in MS Access database (转载)~{8_JVGsVz~}: how to create trigger on a nested table?
相关话题的讨论汇总
话题: create话题: access话题: view