1,216
社区成员
发帖
与我相关
我的任务
分享救我啊，在线等待
这个为什么不行，总是说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
...全文
请发表友善的回复…
发表回复
nineclock 2003-12-07
- 打赏
- 举报
呵呵，行了
谢谢
谢谢
sujiang 2003-12-05
- 打赏
- 举报
adCmdTable 改为adCmdText
我就是用这个。
我就是用这个。
SoHo_Andy 2003-12-05
- 打赏
- 举报
试试adCmdTable->adCmdText
rs1.Open "SELECT cjob.IDCARD,cjob.name,cjob.sex From cjob,success WHERE cjob.IDCARD=success.身份证号", cnn, adOpenDynamic, adLockOptimistic, adCmdText
rs1.Open "SELECT cjob.IDCARD,cjob.name,cjob.sex From cjob,success WHERE cjob.IDCARD=success.身份证号", cnn, adOpenDynamic, adLockOptimistic, adCmdText
JoAiron 2003-12-05
- 打赏
- 举报
做多个表的交叉查询时要这样写
select a.idcard,a.name, a.sex from cjob a, success b where a.idcard = b.no
select a.idcard,a.name, a.sex from cjob a, success b where a.idcard = b.no
nineclock 2003-12-05
- 打赏
- 举报
不行啊
fuzq 2003-12-05
- 打赏
- 举报
rs1.Open "SELECT cjob.IDCARD,cjob.name,cjob.sex From cjob,success WHERE cjob.IDCARD='success.身份证号'", cnn, adOpenDynamic, adLockOptimistic, adCmdTable
