how to do this

[Quoted] JURISDICTION YEAR TOTAL_POPBIRTHS DEATHS NET_MIGRATION INTERNATIONAL DOMESTIC

Delaware	1996	727113	10137	6459	4352	1347	2911	143	-49
Delaware	1998	743603	10110	6235	4209	1254	3027	89	-30
Kent		1998	124089	1745	785	534	124	332	56	-2
Sussex		1998	136707	1623	1254	2334	2567	2677	4	-7
New Castle	1998	482807	5698	3946	1078	1062	189	21	-38
Delaware	1997	735143	10297	6340	4503	1417	3082	72	-68
Kent		1997	122738	1808	976	519	137	337	54	-9
New Castle	1997	478744	6718	3849	1194	1061	190	16	-73
Sussex		1997	133661	1771	1515	2790	219	2555	2	14
Kent		1996	121652	1840	1009	255	126	39	107	-17
Sussex		1996	131078	1748	1522	2357	222	2159	5	-29
New Castle	1996	468744	6617	3765	1067	1145	178	18	-9

and I want to dissect it into tables by subject:

Total Population                 

REGION		Y1996	Y1997	Y1998
Kent		121652	122738	124089
Sussex		131078	133661	136707
Delaware	727113	735143	743603
New Castle	468744	478744	482807

Births                 

REGION		Y1996	Y1997	Y1998
Sussex		1748	1771	1623
New Castle	6617	6718	5698
Kent		1840	1808	1745
Delaware	10137	10297	10110


Deaths			
REGION		Y1996	Y1997	Y1998
Sussex		1522	1515	1254
New Castle	3765	3849	3946
Kent		1009	976	785
Delaware	6459	6340	6235

etc

Please give me a general idea on how to do this nested queries? procedures? I would like to see a procedure but I don't know how? Received on Mon Jun 28 1999 - 20:31:23 CEST