用连接还是分开好啊
请问这两个方式哪一个更好啊
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好