急 帮小弟我看上这个SQL语句对或者错了

急 帮我看下这个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
------解决方案--------------------

SQL code

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