用连接还是分开好啊
请问这两个方式哪一个更好啊
1
sql= "select t2.city from povince as t1 inner join city as t2 on t1.info_id = t2.type_id where t1.province = ' "&province& " ' "

2
pv = conn.Execute( "select info_id from povince where province = ' "&province& " ' ")(0)
sql = "select city from city where type_id = "&pv

[解决办法]
１好，只查一次，２要次ＰＩＯ高些

[解决办法]
1好