这样写SQL语句 哪里出了错误

Jason劣劣劣

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150159; 提示: 保存的列必须包含主语, 要保存的列"[GRC_RM_Risk, GRC_ORG_Organization, GRC_ORG_Organization[1]]", 主语"[GRC_RM_Risk, GRC_ORG_Organization]"
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.data.impl.TableImpl.extractSaveColumn(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.szyt.bex5.grc.risk.RiskHelper.wfSaveDetailRisk(RiskHelper.java:84)
        at RiskManage.risk_wf_saveDetail_Risk(RiskManage.java:255)
        ... 30 more

sql = "select GRC_RM_Risk.*,GRC_ORG_Organization,GRC_ORG_Organization2,GRC_ORG_Organization.name as duty_org_name2, GRC_ORG_Organization2.name as management_org_name2 " +
                                                "from GRC_RM_Risk GRC_RM_Risk " +
                                                "optional join GRC_ORG_Organization GRC_ORG_Organization on GRC_ORG_Organization=GRC_RM_Risk.duty_org_id " +
                                                "optional join GRC_ORG_Organization GRC_ORG_Organization2 on GRC_ORG_Organization2=GRC_RM_Risk.management_org_id " +
                                                "where GRC_RM_Risk=:risk_id";
谢谢！

jishuang

queryActionde idcolumn怎么设置的？