ON epd.erp_productid = ep.erp_productiderp_product_category AS epc ON epc.erp_productid =ep.erp_productiderp_mlbcategory_erpcategory AS emc ON emc.erp_categoryid = epc.erp_categoryidINNER JOIN
erp</em
在更新查询时,我得到这个错误,单行子查询返回多行,这是我的更新查询
UPDATE GT_POLICY GP SET (ERP_POLICY_NO,ERP_INSERT_DATE,ERP_CUSTOMER_ID) = (SELECT ERP.POLICY_NUMBER,ERP.ISSUE_DATE,ERP.MDM_ID FROM ERP_POLICY_DETAILS ERP WHERE GP.ALTERNATE_POLICY_NO=ERP</em