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数据库
ado访问Assess数据库
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'
看看这个行吗.