22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT CAL.OPR_NO ,
CAL.CONS_NO ,
CAL.PURP_GC ,
CAL.PURP_ATM ,
CAL.RTIME ,
QUER.CONS_NAME ,
QUER.DAME_NO ,
JOB.XH ,
JOB.JOX_NAME
FROM CAL
JOIN QUER ON QUER.ACCT_NO = CAL.ACCT_NO
JOIN JOB ON JOB.ACCT_NO = QUER.ACCT_NO
WHERE CAL.ID = 100
如果需要显示,就和其他列一样select出来就行了[/quote]
弄出来了! 谢谢你们。感谢!SELECT CAL.OPR_NO ,
CAL.CONS_NO ,
CAL.PURP_GC ,
CAL.PURP_ATM ,
CAL.RTIME ,
QUER.CONS_NAME ,
QUER.DAME_NO ,
JOB.XH ,
JOB.JOX_NAME
FROM CAL
JOIN QUER ON QUER.ACCT_NO = CAL.ACCT_NO
JOIN JOB ON JOB.ACCT_NO = QUER.ACCT_NO
WHERE CAL.ID = 100
如果需要显示,就和其他列一样select出来就行了SELECT CAL.OPR_NO ,
CAL.CONS_NO ,
CAL.PURP_GC ,
CAL.PURP_ATM ,
CAL.RTIME ,
QUER.CONS_NAME ,
QUER.DAME_NO ,
JOB.XH ,
JOB.JOX_NAME
FROM CAL
JOIN QUER ON QUER.ACCT_NO = CAL.ACCT_NO
JOIN JOB ON JOB.ACCT_NO = QUER.ACCT_NO
select a.acct_no,a.opr_no,a.cons_no,a.purp_gc,a.purp_atm,a.ptime,
b.cons_name,b.dame_no,c.xh,c.jox_name
from cal a join quer b on a.acct_no = b.acct_no
join job c on a.acct_no = c.acct_no