SQL语句..(10分)

zhblc · 2002-03-29

select * from url where node= (select node from node where pro_node='ABC');我在
sql explorer中可以得到数据,但放到程序中就不行了.要怎样才可以.是MS ACCESS

f950436 · 2002-03-29

select * from url where node in (select node from node where pro_node='ABC');

zhblc · 2002-03-29

还是不行. error: ')' expected but identifier 'select' found.

zhblc · 2002-03-29

kingdeezj · 2002-03-29

select * from url where node= "("select node from node where pro_node='ABC'")"

zxb200 · 2002-03-30

這樣看看：
adoquery1.close;
adoquery1.sql.text:='select * from url where node in (select node from node where pro_node=''ABC'')';
adoquery1.open;