只用一个记录得到ID后查询在另个表的字段属性！

dim TodayDate,strIsLockId,sql,i

Set Rs = server.createobject("ADODB.Recordset")



TodayDate = Qsite.FormatDate(Date())



strIsLockId = IsLockId("Company")

Sql = "select top "& Qsite.IndNewzp &" * from RecruitTb1 where ValidityDate > '"& TodayDate &"' and jjzp='1' and IsPause = '0' and ComId not in ("& strIsLockId &") order by EditDate desc"

Rs.Open Sql , Conn , 1 , 1
以上是得到 表 RecruitTb1 的记录里面有ComId字段！另外一个表ConpanyTbl也有ComId
我要以表 RecruitTb1的记录ComId查出CompanyTbl里MemberType字段属性！