sql查询语名

[rufer]

select flower.id,flower.num,flower.name,flower.date,flower.mem from flower,lclient,(select * from client where name = '123') where lclient.clientid=client.id and lclient.flowerid=flower.id

为什么这样的语名在SQL Explorer可以运行，而加入adoquery的SQL中这不能得到数据啊？
ado访问Assess数据库

[rufer]

在线。请指教

[Tensionli]

ACCESSK中不能使用嵌套,还是想别的办法吧
select flower.id,flower.num,flower.name,flower.date,flower.mem
from flower,lclient,client
where lclient.clientid=client.id and lclient.floweid=flower.id and client.name='123'
看看这个行吗.