急 帮我看下这个SQL语句对或者错了 在线等
select A.id,A.payer,A.state,A.path,A.acceptanceid,A.ispay,A.ordercontentid,A.dispose,B.tempId,B.ID,B.wktmps,B.metas
FROM CA_ORDER_INFO A,CA_ORDER_CONTENT B WHERE B.ID = (select CA_ORDER_INFO.ORDERCONTENTID FROM CA_ORDER_INFO where ISPAY=0 and STATE=0)
感觉就像是错了
就是 通过 （select CA_ORDER_INFO.ORDERCONTENTID FROM CA_ORDER_INFO where ISPAY=0 and STATE=0)得到符合标准的 ORDERCONTENTID 然后再从另外一个表中利用ORDERCONTENTID=*。ID 取出相关数据的SQL语句
[解决办法]
select A.id,A.payer,A.state,A.path,A.acceptanceid,A.ispay,A.ordercontentid,A.dispose,B.tempId,B.ID,B.wktmps,B.metas
FROM CA_ORDER_INFO A,CA_ORDER_CONTENT B ,(select CA_ORDER_INFO.ORDERCONTENTID FROM CA_ORDER_INFO where ISPAY=0 and STATE=0)C WHERE B.ID = C.ORDERCONTENTID
[解决办法]
SELECT A.ID, A.PAYER, A.STATE, A.PATH, A.ACCEPTANCEID, A.ISPAY, A.ORDERCONTENTID, A.DISPOSE, B.TEMPID, B.ID, B.WKTMPS, B.METAS FROM CA_ORDER_INFO A, CA_ORDER_CONTENT B WHERE B.ID = A.ORDERCONTENTID AND A.ISPAY = 0 AND A.STATE = 0
