呵呵,好好看看SQL语句吧~~ RSUser2.open"Select * From homephone1 Where Home_Tel=
(Select Home_Tel From Worker_inf Where ID_Worker='"&W_ID&"')" ,conn2
()里面本身就是一个记录集不能这样取地!
呵呵~~试试这个:
RSUser2.open"Select * From homephone1 Where Home_Tel in Select Home_Tel From Worker_inf Where ID_Worker='"&W_ID&"')"
(Select Home_Tel From Worker_inf Where ID_Worker='"&W_ID&"')" ,conn2
()里面本身就是一个记录集不能这样取地!
呵呵~~试试这个:
RSUser2.open"Select * From homephone1 Where Home_Tel in Select Home_Tel From Worker_inf Where ID_Worker='"&W_ID&"')"
(Select Home_Tel From Worker_inf Where ID_Worker='"&W_ID&"')" ,conn2
错了!!!!!怎么可能有一条记录等于一个记录集呢???
请把“=”改成"in"
RSUser2.open"Select * From homephone1 Where Home_Tel in
(Select Home_Tel From Worker_inf Where ID_Worker='"&W_ID&"')" ,conn2
好好看看SQL语句:)呵呵~~~