SELECT * FROM (SELECT * FROM UserTable WHERE expuid < 5) DERIVEDTBL 我看这些代码都没错,建议你先用数据库的查询分析器试试
全句如下:(我真不知道错在什么地方) Rec1.Open ("Select * From (Select * From t_JiChenTable Where ZT='0') Where FaBaoSheHao='025'"), Con1, adOpenKeyset, adLockOptimistic, adCmdText
Select * From t_JiChenTable Where ZT='0' and FaBaoSheHao='025'用查询分析器试试
不知道是不是你拷错了: Rec1.Open "Select * From (Select * From t_JiChenTable Where ZT='0') Where FaBaoSheHao='025'", Con1, adOpenKeyset, adLockOptimistic, adCmdText
奇怪 爲什麽不寫成 Select * From t_JiChenTable Where ZT='0' and FaBaoSheHao='025'
楼上的同志,,都有分我的脑袋进水了Select * From t_JiChenTable Where ZT='0' and FaBaoSheHao='025'本来可以用上面这么简单的数据写,,为何写成刚刚给大家的样子而且我还没有察觉有何不妥我自己都感到有点莫明奇妙,,怎么会有这种奇怪的想法。。
Select * From t_JiChenTable Where (ZT='0' and FaBaoSheHao='025') 可以吗?
没有错呀!
FROM (SELECT *
FROM UserTable
WHERE expuid < 5) DERIVEDTBL
说的没有错。
Select * From t_JiChenTable Where ZT='0'
在被上一层的select查询的时候,没有指定条件!!!!不能重复生成相同的结果集
这样的嵌套查询无效!!
仔细看看?是不是只有一句话就行了?
FROM (SELECT *
FROM UserTable
WHERE expuid < 5) DERIVEDTBL
我看这些代码都没错,建议你先用数据库的查询分析器试试
Rec1.Open ("Select * From (Select * From t_JiChenTable Where ZT='0') Where FaBaoSheHao='025'"), Con1, adOpenKeyset, adLockOptimistic, adCmdText
Rec1.Open "Select * From (Select * From t_JiChenTable Where ZT='0') Where FaBaoSheHao='025'", Con1, adOpenKeyset, adLockOptimistic, adCmdText
爲什麽不寫成
Select * From t_JiChenTable Where ZT='0' and FaBaoSheHao='025'
可以吗?