select *
from (select temp.*, rownum row_id
from (select l.*,
M.mcol1,
R.rcol1,
R.rcol2,
B.col1,
B1.col1 --这里需要取与B同一个字段的值但是条件不同
from table_l
JOIN TABLE_R R
ON L.ID = R.R_ID
JOIN TABLE_M M
ON L.TYPE = M.TYPE
JOIN TABLE_B B
ON L.CODE = B.CODE
JOIN TABLE_B1 B1
ON L.ATYPE = B1.CODE
WHERE B.CODE = 'T'
AND B1.CODE = 'A') temp
where rownum <= 10)
where row_id > 0
执行后提示temp未明确定义 怎么回事