这么简单的语句在access不能运行？

[gdmm919705]

SELECT id as idstr from user where idstr=1

[ACMAIN_CHM]

SELECT id as idstr from [user] where idstr=1 尝试一下，另外错误提示是什么？这个语句应该没有问题。

[gdmm919705]

引用 1 楼 ACMAIN_CHM 的回复:

SELECT id as idstr from [user] where idstr=1

尝试一下，另外错误提示是什么？这个语句应该没有问题。

弹出对话框提示输入idstr参数值，当我输入已存在的id为1时，查出所有记录。难道access 没实现这个语法吗

[ACMAIN_CHM]

SELECT id as idstr from [user] where id=1

[gdmm919705]

引用 3 楼 ACMAIN_CHM 的回复:

SELECT id as idstr from [user] where id=1

我只是举例，因为我要用到switch来判断
SELECT switch(type=1,'类型1',type=0,'类型2') as type_name from table where type_name='类型1'

[ACMAIN_CHM]

SELECT switch(type=1,'类型1',type=0,'类型2') as type_name from table where switch(type=1,'类型1',type=0,'类型2') ='类型1' select * from (SELECT switch(type=1,'类型1',type=0,'类型2') as type_name from table) t where type_name='类型1'