My SQL 子查询

1 Introduction

In the mysql there is query with before query result as conditon.

2 Detail

Result1

SELECT
	B.MBLNR "领料单号",     
	B.werks "工厂",     
	B.BUDAT_MKPF "领料日期",  
	b.CPUDT_MKPF "建单日期"   ,
	B.XBLNR_MKPF "发料单", 
	ZBAR_HEAD.ERDAT "发料日期" ,
	AFPO.PSMNG "生产数量",   
	AFPO.WEMNG "完工入库数量",  
	resb.BDMNG "应发数量",    
	B.MENGE "异动数量",       
	A.ZREASON "补料类型代码",    
	ZPPT0025.ZREAMSG "补料类型", 
	ZBAR_HEAD.BKTXT "补料备注",
	VBAK.VBELN "销售单号（按单生产）",       
	B.MATNR "原物料号",     
	A.MAKTX "物料描述",     
	A.AUFNR "生产工单",      
	VBAK.KUNNR "客户编号", 
	KNA1.NAME1 "客户名字" ,
	AFKO.PLNBEZ "成品物料号", 
	makt.MAKTX "成品物料名称" ,
	a.KOSTL    "成本中心"   
--	d.NAME1  "部门名称"
	
FROM
	NSDM_V_MSEG B
LEFT JOIN ZBAR_ITEM A ON
	B.XBLNR_MKPF = A.ID
	AND B.LINE_ID = A.CANUM
INNER JOIN ZBAR_head ON
	B.