oraclede sql语句错误，怎么解决？

Question

这是sql语句
[code="java"]
resultMap="result">
<![CDATA[

SELECT
SUPPLIER_ID,
ACCESS_CODE,
SUPPLIER_NAME,
IP,
PORT,
STATUS,
COMMUNICATE_TYPE,
PROTOCOL_TYPE,
REPLACE_FLAG,
ACCOUNT,
PASSWORD,
M1,
IA1,
IC1,
Del_Flag
FROM (
SELECT

SUPPLIER_ID,
ACCESS_CODE,
SUPPLIER_NAME,
IP,
PORT,
STATUS,
COMMUNICATE_TYPE,
PROTOCOL_TYPE,
REPLACE_FLAG,
ACCOUNT,
PASSWORD,
Del_Flag,
M1,
IA1,
IC1,
Del_Flag,
rownum as row_num
FROM (

SELECT

SUPPLIER_ID,
ACCESS_CODE,
SUPPLIER_NAME,
IP,
PORT,
STATUS,
COMMUNICATE_TYPE,
PROTOCOL_TYPE,
REPLACE_FLAG,
ACCOUNT,
PASSWORD,
M1,
IA1,
IC1,
Del_Flag
from MST_Supplier
WHERE Del_Flag=0
]]>
[/code]
这是错误信息
[code="java"]
--- The error occurred while applying a parameter map.

--- Check the MS_FIND_Suppliers-InlineParameterMap.

--- Check the statement (query failed).

--- Cause: java.sql.SQLException: ORA-00918: 未明确定义列
[/code]
望解决。

Answer 1

未明确定义列：
检查一下表的字段，肯定在2个表里有相同名字的字段，给字段加上表名然后试下