我知道这个查询语句是错的可是不知道怎么改，哪位大虾帮帮忙  select * from test a left join PersonTbl b on a.PerId=b.PerId where PerId = "& PerId

为什么没人回答我的问题

我想根据已经知道的PerId值，去查询有关系的2个表

能不能用事务来表达，但是事务怎么写啊

我这样写行吗  
conn.begintrans
Rs.Open "select * from PersonTbl where PerId = "& PerId , Conn , 1 , 1
If Rs.Eof Then
    Question = ""
    Answer = ""
    Email = ""
   
    RealName = ""
    Sex = ""
    Age = ""
    Nation = ""
    Political = ""
    Birthplace = ""
    Marriage = ""
    Qualification = ""
    Standing = ""
    Weight = ""
    Salary = ""
    Nature = ""
    Position_b = ""
    Position_s = ""
    JobPost = ""
    areaname = ""
    NowAddr = ""
    HomeAddr = ""
    QQ = ""
    MSN = ""
    Tel = ""
    Mobile = ""
   
    IsHidden = ""
    IsLock = ""
    IsTj = ""
    IsGj = ""
    IsSh = ""
    LoginQuantity = ""
    ThisLoginDate = ""
    ThisLoginIp = ""
    ViewQuantity = ""
   
    RegFromIp = ""
    RegDate = ""
Else
   
    Question = Rs("Question")
    Answer = Rs("Answer")
    Email = Rs("Email")
   
    RealName = Rs("RealName")
    Sex = Rs("Sex")
    Age = Rs("Age")
    Nation = Rs("Nation")
    Political = Rs("Political")
    Birthplace = Rs("Birthplace")
    Marriage = Rs("Marriage")
    Qualification = Rs("Qualification")
    Standing = Rs("Standing")
    Weight = Rs("Weight")
    Salary = Rs("Salary")
    Nature = Rs("Nature")
    Position_b = Rs("Position_b")
    Position_s = Rs("Position_s")
    JobPost = Rs("JobPost")
    areaname = Rs("areaname")
    NowAddr = Rs("NowAddr")
    HomeAddr = Rs("HomeAddr")
    QQ = Rs("QQ")
    MSN = Rs("MSN")
    Tel = Rs("Tel")
    Mobile = Rs("Mobile")
   
    IsHidden = Rs("IsHidden")
    IsLock = Rs("IsLock")
    IsTj = Rs("IsTj")
    IsGj = Rs("IsGj")
    IsSh = Rs("IsSh")
    LoginQuantity = Rs("LoginQuantity")
    ThisLoginDate = Rs("ThisLoginDate")
    ThisLoginIp = Rs("ThisLoginIp")
    ViewQuantity = Rs("ViewQuantity")
    RegFromIp = Rs("RegFromIp")
    RegDate = Rs("RegDate")
End If
Rs.Close
if Conn.Errors.Count>0 then
    Conn.Errors.Clear
    Conn.RollBackTrans
    response.Redirct "Person_Edit.asp"
   End if
rs.open "select * from test where PerId = "& PerId , Conn , 1 , 1
If Rs.Eof Then
    UserName = ""
    PassWord = ""
Else
    UserName = Rs("UserName")
    PassWord = Rs("PassWord")
    End if
    Rs.Close
if Conn.Errors.Count>0 then
   Conn.Errors.Clear
   Conn.RollBackTrans
   response.Redirct "Person_Edit.asp"
End if
   

恩有道理，我想问一下在一个页面里可以同时用
<!--#include file="Conn.asp" -->
<!--#include file="Conn1.asp"-->
吗？？2个是不同的数据库

2个数据库能嵌套使用吗？？有谁试过
Rs1.open "select * from test1",conn1,3,2
 Rs.open "select * from test",conn,3,2
rs.close
rs1.close

经过尝试以后我发现2个数据库能嵌套的

例如：Rs.open "Select * from test where id=1",conn,1,1
      if Not Rs.Eof Then
      response.write("有记录")
      Esle
       Rs1.Open "Select * from test1 where id=1",conn1,1,1
      if Not Rs1.Eof Then
        response.write("有记录")
      Else
        response.write("没记录")
      End if
     Rs1.close
  End if
Rs.close
至于同一个数据库能不能用conn 和conn1 来实现上面的功能，我就没试过了。

请教 把2个数组放在另一个数组里 怎么写
A（5）={1，2，3，4，5}
B（2）={6，7}
合并为
C(7)={1,2,3,4,5,6,7,}

asp 语句