Query SELECT P.Person_ID, Last_Name, First_Name,RID, type,PY,Reason,C.person_id,completed,Due_Date,Submit_Date,comments FROM PERSON P left join COMPLIANCE C on C.person_id=P.Person_ID where type='Ext Grant'order by Last_Name, First_Name, Mon Jul 18 14:58:26 2005

Person_ID	Last_Name	First_Name	RID	type	Reason	person_id	completed	Due_Date	Submit_Date	comments
8	Alexander	Brad	809	Ext Grant	1057	8	N/A
122	Bafuma	Patrick	939	Ext Grant	2082	122	N/A
240	Ballentine	Danny	1066	Ext Grant	3031	240	N/A
261	Banschbach	Valerie	471	Ext Grant	3039	261	No	2005-06-01
241	Bouchard	Addison	1082	Ext Grant	3025	241	N/A
123	Brendtro	Stacy	944	Ext Grant	2086	123	N/A
19	Brizard	Alain	371	Ext Grant	1001	19	Yes	2003-09-30	2003-04-09
69	Brooks	Lionel	818	Ext Grant	1032	69	N/A
259	Brunelle	Ann	1091	Ext Grant	3026	259	N/A
141	Bucci	David	324	Ext Grant	2057	141	Yes	2004-12-31	2004-02-01
24	Bunt	Richard	347	Ext Grant	1002	24	Yes	2004-05-31	2002-01-20
46	Choi	Sunhee	353	Ext Grant	1003	46	Yes	2004-05-31	2002-09-24
46	Choi	Sunhee	608	Ext Grant	2046	46	N/A
46	Choi	Sunhee	468	Ext Grant	3038	46	No	2005-06-01
18	Cluss	Robert	465	Ext Grant	3037	18	No	2005-06-01
18	Cluss	Robert	377	Ext Grant	1004	18	Yes	2003-09-30	2003-09-25
254	Courchesne	Renee	1115	Ext Grant	3034	254	N/A
310	Dalhgren	Lars	1124	Ext Grant	3033	310	N/A
144	Delay	Rona	312	Ext Grant	2055	144	Yes	2004-12-31	2003-09-26
124	DuBois	Ryan	950	Ext Grant	2081	124	N/A
161	Dumont	Kristyn	1134	Ext Grant	3015	161	N/A
125	Ellis-Monaghan	Joanna	383	Ext Grant	2094	125	Yes	2004-09-30	2003-10-01
125	Ellis-Monaghan	Joanna	1143	Ext Grant	3050	125	N/A
125	Ellis-Monaghan	Joanna	956	Ext Grant	2094	125	N/A
125	Ellis-Monaghan	Joanna	474	Ext Grant	3050	125	No	2005-06-01
100	Eppstein	Margaret	321	Ext Grant	2058	100	No	2004-12-31
126	Findley	Bret	480	Ext Grant	3042	126	No	2005-06-01		Will submit on 1/06
126	Findley	Bret	386	Ext Grant	2093	126	No	2004-09-30
40	Finette	Barry	562	Ext Grant	1017	40	N/A
40	Finette	Barry	297	Ext Grant	1027	40	No	2003-11-30
40	Finette	Barry	561	Ext Grant	1018	40	N/A
23	Fisher	Alison	356	Ext Grant	1005	23	Yes	2003-09-30	2004-01-07
246	Gardner	Brooke	1159	Ext Grant	3027	246	N/A
250	Gauvin	Timothy	1169	Ext Grant	3014	250	N/A
127	Genter	Robert	477	Ext Grant	3040	127	No	2005-06-01
127	Genter	Robert	389	Ext Grant	2092	127	No	2004-09-30
47	Giordano	Rosanna	610	Ext Grant	2059	47	N/A
264	Gomez	Concetta	489	Ext Grant	3046	264	No	2005-06-01
102	Green	Douglas	401	Ext Grant	2091	102	No	2004-09-30
233	Gulka	Ann	1193	Ext Grant	3013	233	N/A
14	Guy	Jennifer	841	Ext Grant	1019	14	N/A
41	Harris	Jeanne	294	Ext Grant	1012	41	Yes	2003-11-30	2003-01-15
249	Hewitt	Rebecca	1202	Ext Grant	3024	249	N/A
242	Holmes	Margaret	1212	Ext Grant	3017	242	N/A
43	Hovey	Russell	588	Ext Grant	1013	43	N/A
11	Jiang	Yuqiu	846	Ext Grant	1021	11	N/A
85	Johnson	Douglas	309	Ext Grant	2060	85	Yes	2004-12-31	2003-10-31
20	Karstens	William	374	Ext Grant	1007	20	Yes	2003-09-30	2003-10-31
44	Kilpatrick	William	552	Ext Grant	1016	44	N/A
1	Klayman	Andrea	855	Ext Grant	1055	1	N/A
260	Kosciak	Emma Kosciak	1221	Ext Grant	3028	260	N/A
245	Lambert	Christine	1230	Ext Grant	3029	245	N/A
128	LaRoche	Dain	413	Ext Grant	2098	128	No	2004-09-30
25	Larrabee	James	427	Ext Grant	2087	25	Yes	2005-05-31	2004-07-29
25	Larrabee	James	492	Ext Grant	3044	25	Yes	2005-06-01	2005-07-24
129	Larson	Ryan	984	Ext Grant	2080	129	N/A
9	Leung	Chin Hin	856	Ext Grant	1020	9	N/A
49	Lippert	Malcolm	622	Ext Grant	2047	49	N/A
49	Lippert	Malcolm	368	Ext Grant	1008	49	No	2003-09-30
50	Lounsbury	Karen	624	Ext Grant	2048	50	N/A
50	Lounsbury	Karen	630	Ext Grant	3005	50	N/A
21	Lubkowitz	Mark	392	Ext Grant	2090	21	No	2004-09-30
21	Lubkowitz	Mark	459	Ext Grant	3035	21	Yes	2005-06-01	2005-07-11
21	Lubkowitz	Mark	365	Ext Grant	1009	21	Yes	2003-09-30	2003-07-09
51	Luimes	Paul	635	Ext Grant	2049	51	N/A
130	Lynch	Shane	994	Ext Grant	2078	130	N/A
52	Martinsen	Ellen	644	Ext Grant	2050	52	N/A
243	Matthews	Aubrey	1255	Ext Grant	3019	243	N/A
53	May	Victor	650	Ext Grant	2051	53	N/A
265	Mondanaro	Kathleen	495	Ext Grant	3047	265	Yes	2005-06-01	2004-08-06
143	Morielli	Anthony	315	Ext Grant	2056	143	Yes	2004-12-31	2004-02-01
131	Moulton	Cynthia	398	Ext Grant	2089	131	No	2004-09-30
2	Murphy	Joan	875	Ext Grant	1056	2	N/A
15	Nicole	Julie	1003	Ext Grant	2088	15	N/A
15	Nicole	Julie	880	Ext Grant	1033	15	N/A
252	okwan-duodu	derick	1272	Ext Grant	3030	252	N/A
22	Page	Scott	380	Ext Grant	1035	22	Yes	2003-09-30	2003-09-22
17	Parfitt	David	430	Ext Grant	2077	17	No	2004-09-30
17	Parfitt	David	362	Ext Grant	1011	17	Yes	2003-09-30	2003-03-14
267	Peterson	William	454	Ext Grant	3049	267	No	2005-06-01
132	Rabideau	Jessica	1012	Ext Grant	2079	132	N/A
251	Randall	Julia	1286	Ext Grant	3023	251	N/A
3	Rey	Michelle	893	Ext Grant	1054	3	N/A
133	Reynolds	Steven	410	Ext Grant	2076	133	No	2004-09-30
217	Root	Thomas	486	Ext Grant	3036	217	No	2005-06-01
13	Rudolph	Adam	898	Ext Grant	1022	13	N/A
256	Sachdeva	Harmeet	1303	Ext Grant	3032	256	N/A
7	Saltstein	Katherine	903	Ext Grant	1030	7	N/A
231	Sandwick	Roger	498	Ext Grant	3041	231	No	2005-06-01
134	Sarkar	Amrita	1022	Ext Grant	2085	134	N/A
135	Schoenly	Joshua	1320	Ext Grant	3020	135	N/A
135	Schoenly	Joshua	1028	Ext Grant	2099	135	N/A
16	Sheldon	Sallie	359	Ext Grant	1034	16	Yes	2003-09-30	2002-07-16
16	Sheldon	Sallie	462	Ext Grant	3043	16	Yes	2005-06-01	2004-07-10
5	Slack	Kelly	913	Ext Grant	1028	5	N/A
136	Sontum	Stephen	407	Ext Grant	2097	136	No	2004-09-30
247	Southworth	Krista	1337	Ext Grant	3016	247	N/A
57	Spatafora	Grace	350	Ext Grant	1036	57	Yes	2004-05-31	2003-03-03
57	Spatafora	Grace	651	Ext Grant	2054	57	N/A
248	Steinberg	Emily	1347	Ext Grant	3021	248	N/A
4	Stenmark	Matthew	923	Ext Grant	1029	4	N/A
56	Trott	Josephine	662	Ext Grant	2053	56	N/A
266	Van Houten	John	456	Ext Grant	3048	266	No	2005-06-01
137	Velez	Carlos	404	Ext Grant	2096	137	Yes	2004-09-30	2004-03-01
138	Viani	Kyle	1045	Ext Grant	2084	138	N/A
142	Vichi	Paul	318	Ext Grant	2052	142	Yes	2004-12-31	2004-01-28
42	Vigoreaux	Jim	291	Ext Grant	1015	42	Yes	2003-11-30	2003-01-15
42	Vigoreaux	Jim	292	Ext Grant	1014	42	Yes	2003-11-30	2003-01-15
139	von Hasseln	Kyle	1052	Ext Grant	2083	139	N/A
139	von Hasseln	Kyle	1363	Ext Grant	3018	139	N/A
232	Ward	Jeremy	483	Ext Grant	3045	232	No	2005-06-01		Will submit on 9/25/05
6	Wessler	Benjamin	928	Ext Grant	1023	6	N/A
10	Whittinghill	Kyle	933	Ext Grant	1031	10	N/A
140	Young	Helen	395	Ext Grant	2095	140	No	2004-09-30