满足3个条件，返回值求助

staryang0606

即表1中标注颜色的3个条件=表2标注颜色的3个条件等同的状况下，将表2中的Issued值返回到表1中的I档扣账记录中。

谢谢，请指教！！

表1：

WIP_NO	OPERATION_SEQ_NUM	MAIN_ITEM	REEL_ITEM_NO	类别	SUBINVENTORY_CODE	LOCATION_NAME	ISSUED	扣账记录	差异
16D009580N	5010	C11-1012012-W08	C11-1012012-W08	C11	RGW	RGW-KDAV	2163		2163
16D009580N	5010	C11-1022012-W08	C11-1022012-W08	C11	RGW	RGW-KDAV	3236
16D009580N	5010	C11-1032012-W08	C11-1032012-W08	C11	RGW	RGW-KDAV	3236
16D009580N	5010	C11-1032822-W08	C11-1032822-W08	C11	RGW	RGW-KDAV	12883
16D009580N	5010	C11-1042012-Y01	C11-1042542-S02	C11	RGW	RGW-KDAV	5378
16D009580N	5010	C11-1042023-W08	C11-1042023-W08	C11	RGW	RGW-KDAV	1089
16D009580N	5010	C11-1042042-W08	C11-1042042-W08	C11	RGW	RGW-KDAV	27895
16D009580N	5010	C11-1042812-Y01	C11-1042812-M09	C11	RGW	RGW-KDAV	32150
16D009580N	5010	C11-1042813-W08	C11-1042813-W08	C11	RGW	RGW-KDAV	8594
16D009580N	5010	C11-1043612-W08	C11-1043612-W08	C11	RGW	RGW-KDAV	1089
16D009580N	5010	C11-1047312-W08	C11-1047312-W08	C11	RGW	RGW-KDAV	10741
16D009580N	5010	C11-1047612-W08	C11-1047612-W08	C11	RGW	RGW-KDAV	8594
16D009580N	5010	C11-1052024-W08	C11-1052024-Y01	C11	RGW	RGW-KDAV	1089

表2：

Job	WIP Supply Type	Component	Op Seq	Required	Issued
16D009580N	Push	307-6H20211-C22	6010	1070	1070
16D009582N	Push	307-6H20211-C22	6010	1000	1000
16D009695N	Push	307-6H20211-C22	6010	200	200
16D009693N	Push	307-6H20211-C22	6010	90	90
16D009694N	Push	307-6H20211-C22	6010	40	40
16D009650N	Push	307-6H20211-C22	6010	202	202
16D009650N	Push	A0C-7300H05-I06	5020	202	202
16D009695N	Push	A0D-7700H05-I06	5020	200	200
16D009693N	Push	A0D-7700H05-I06	5020	90	90
16D009694N	Push	A0D-7700H05-I06	5020	40	40
16D009580N	Push	A0D-7700H05-I06	5020	1070	1070
16D009582N	Push	A0D-7700H05-I06	5020	1000	1000
16D009582N	Push	B01-HM17505-I06	5010	1000	1000
16D009580N	Push	B01-HM17505-I06	5010	1070	1070
16D009650N	Push	B01-HM17505-I06	5010	202	202

desire自由者

发附件上来