请问这两个方式哪一个更好啊
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好