sql="slelect * from t_A Ta,t_B Tb,t_C Tc when Ta.CusId=Tb.ID And Ta.BookID=Tc.ID and Td.Cus='" & Cus & "' "
set rs=getrecordset(sql)
txtID.text = rs("Tc.id")
那里有问题,请大家帮帮忙.
set rs=getrecordset(sql)
txtID.text = rs("Tc.id")
那里有问题,请大家帮帮忙.
调试欢乐多
这一句
sql="select * from t_A Ta,t_B Tb,t_C Tc " _
& "where Ta.CusId=Tb.ID And Ta.BookID=Tc.ID and Td.Cus='" & Cus & "' " _
不好意思,刚才打错了,是这一句.
& " inner join t_A on t_A.BookID=t_C.ID " _
& " inner join t_B on t_A.CusId=t_B.ID " _
& " where t_B.t_Cus='" & Customer & "'"
'有错,改为
txtID.text=rs.fields("Tc.id")
如:select Tc.id from...txtID.text = rs("Tc.id")
txtID.text = rs("id")