SELECTdbd_shuru.dbnum ,
dbd_shuru.prodid ,
dbd_shuru.modelid ,
dbd_shuru.partid ,
dbd_shuru.numcode ,
dbd_shuru.bchck ,
dbd_shuru.brck ,
dbd_ml.modbm ,
dbd_mlm.mlmsh ,
dbd_mlm.danwei ,
dbd_shuru.gpy ,
dbd_shuru.kddate ,
dbd_shuru.cgddh ,
dbd_shuru.price ,
dbd_shuru.shnum ,
dbd_shuru.qnum ,
dbd_shuru.danwei ,
dbd_shuru.xhao ,
dbd_shuru.taif
FROM {oj dbd_shuru LEFT OUTER JOIN dbd_ml ON dbd_shuru.partid = dbd_ml.partid LEFT OUTER JOIN dbd_mlm ON dbd_ml.modbm = dbd_mlm.modbm}
WHERE ( DBD_SHURU.PRODID = :a )
各位帮我看看有什么错??老出现ORA-00933:SQL命令未正确结束,现在根本在数据窗口中取不到数据
|