这个为什么不行,总是说FROM 语句错误
rs1.Open "SELECT cjob.IDCARD,cjob.name,cjob.sex From cjob,success WHERE cjob.IDCARD=success.身份证号", cnn, adOpenDynamic, adLockOptimistic, adCmdTable
rs1.Open "SELECT cjob.IDCARD,cjob.name,cjob.sex From cjob,success WHERE cjob.IDCARD=success.身份证号", cnn, adOpenDynamic, adLockOptimistic, adCmdTable
select a.idcard,a.name, a.sex from cjob a, success b where a.idcard = b.no
我就是用这个。