Header / Detail in a single query.

Chain	Customer	DelDate	      	 Route	PO_Number	ItemNumber	QTY	FLAG
85	23026		20130702	8282	451245		400		5	1
85	23026		20130702	8282	451245		401		3	1
85	23026		20130702	8282	451245		402		8	1
85	23026		20130702	8282	451245		406		3	1
85	23026		20130702	8282	451245		470		2	1
85	23026		20130702	8282	451245		471		1	1
85	23026		20130702	8282	451245		6050		9	1
85	23026		20130702	8282	451245		6080		13	1
85	23026		20130702	8282	451245		6081		15	1
85	23035		20130702	8282	989898		400		5	1
85	23035		20130702	8282	989898		401		3	1
85	23035		20130702	8282	989898		402		8	1
85	23035		20130702	8282	989898		406		3	1
85	23035		20130702	8282	989898		470		2	1
85	23035		20130702	8282	989898		471		1	1
85	23035		20130702	8282	989898		6050		9	1
85	23035		20130702	8282	989898		6080		13	1
85	23035		20130702	8282	989898		6081		15	1

Select allOpen in new window

Chain	Customer	DelDate		Route 	PO_Number	ItemNumber	QTY	FLAG
85	23026		20130702	8282	451245		0		0	0
0	0		0		0	0		400		5	1
0	0		0		0	0		401		3	1
0	0		0		0	0		402		8	1
0	0		0		0	0		406		3	1
0	0		0		0	0		470		2	1
0	0		0		0	0		471		1	1
0	0		0		0	0		6050		9	1
0	0		0		0	0		6080		13	1
0	0		0		0	0		6081		15	1
85	23035		20130702	8282	989898		0		0	0
0	0		0		0	0		400		5	1
0	0		0		0	0		401		3	1
0	0		0		0	0		402		8	1
0	0		0		0	0		406		3	1
0	0		0		0	0		470		2	1
0	0		0		0	0		471		1	1
0	0		0		0	0		6050		9	1
0	0		0		0	0		6080		13	1
0	0		0		0	0		6081		15	1

Select allOpen in new window