oracle 返回一个表,请教怎么从其中一张表里只返回一个特定的记录

SQL codeselect pe.plm_oid,

rm.plm_m_id,

pe.plm_createtime,

pe.plm_newname,

pe.plm_pdwgdate,

pe.plm_ppdwgdate,

pe.plm_pdwgcode,

pe.plm_ppdwgcode,

pe.plm_pdtdesign,

pe.plm_dpdtdesign,

pe.plm_pdwgname,

pe.plm_cxsj,

pe.plm_tzsj,

f.plm_oid,

w.plm_completeddate

from plm_cus_PROJECTECHFILE pe

left join PLM_PSM_FILE f

on pe.PLM_OID = f.PLM_ITEMOID, PLM_PSM_ITEMMASTER_REVISION rm,

PLM_BPMv_WORKITEM w, plm_bpmv_r_group_data_ins i,

plm_cus_r_XMHXMJSWJ x

where i.plm_bosubid = 1

and w.plm_name like '%批准'

and pe.plm_xmjswjfl = '设计任务书-电气'

and i.plm_PROCESSoid = w.plm_processinstanceid

and i.plm_bomoid = rm.plm_m_oid

and rm.plm_m_lastrevision = rm.plm_r_revision

and pe.PLM_ITERATION = rm.plm_r_lastiteration

and rm.plm_r_oid = pe.plm_revisionoid

and x.plm_rightobj = rm.plm_m_oid

and x.plm_leftobj = '917F410F954446F59DD3DB2F5D9B3247'

order by rm.plm_m_id