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
[ERP_STAGE_PROP_MAPPING] where [ERP_SOURCE_TABLE] = '''+@STAGE_TABLE+''' and [ERP_REPORT_COLOMNS] = '[ERP_STAGE_PROP_MAPPING] where [ERP_SOURCE_TABLE] = '''+@STAGE_TABLE+''' and [ERP</em