Oracle sql 报错确实右括号

select distinct(EAF_R_RIGHTID) from BIM_DMM_R_NAVMODEL where EAF_R_LEFTID in
(select t.EAF_ID EAF_ID from BIM_DMM_NAV t where 1=1 and BIM_VIEWID = 'B51CA2C3F36293837D7FEF408A3D8ED2' and BIM_BUILD='D1402C388390D5E46C122C756977037C' and 1 = 1 order by t.Bim_Order)

oracle的我没写过，但是个人感觉：1.BIM_VIEWID BIM_BUILD 是哪个表中的？2.第二个1=1是否多余了？

去掉order by,在in里面order by没意义

 select distinct(EAF_R_RIGHTID) from BIM_DMM_R_NAVMODEL where EAF_R_LEFTID in
(select t.EAF_ID EAF_ID from BIM_DMM_NAV t where 1=1 and BIM_VIEWID = 'B51CA2C3F36293837D7FEF408A3D8ED2' and BIM_BUILD='D1402C388390D5E46C122C756977037C' and 1 = 1 )