SQL> SELECT XK_COUNTY_NAME||';'||VC_OFFICE||';'||VC_LOCATION||';'||VC_PARTY 2 ||';'||VC_CN_FNAME||';'||VC_CN_MIDI||';'||VC_CN_LNAME||';'|| 3 VC_CN_SNAME||';'||VC_CN_CAN_MAILADDR1||';'||VC_CN_CAN_MAILADDR2||';'|| 4 VC_CN_CITY||';'||VC_CN_STATE||';'||SUBSTR(VC_CN_ZIP,1,5) 5 FROM VREFVC, TREFXK 6 WHERE VC_ELECTION_STATUS_CODE = 1 7 AND VC_EL_FILEDWITH_CODE in (1, 2, 3) 8 AND VC_EL_FILEDWITH_COUNTY_CODE = XK_COUNTY_CODE 9 AND VC_EL_BA_ED_SEQ = 289 10 ORDER BY VC_EL_FILEDWITH_COUNTY_CODE, VC_OFFICE, VC_LOCATION, VC_CN_LNAME 11 / JEFFERSON;LEGISLATIVE COUNCIL - EVEN;JEFFERSON-DIST 10;DEMOCRAT;JEFF;;NOBLE;;1003 ELLISON AVENUE;;LOUISVILLE;KY;40232 JEFFERSON;LEGISLATIVE COUNCIL - EVEN;JEFFERSON-DIST 12;DEMOCRAT;RICK;;BLACKWELL;;6712 MARIAN DRIVE;;LOUISVILLE;KY;40216 JEFFERSON;LEGISLATIVE COUNCIL - EVEN;JEFFERSON-DIST 14;REPUBLICAN;DIANA;;NEWTON;;10000 MOON BEAM CT;;LOUISVILLE;KY;40272 JEFFERSON;LEGISLATIVE COUNCIL - EVEN;JEFFERSON-DIST 22;REPUBLICAN;ROBIN;J.;ENGEL;;5601 PAVILION WAY;;LOUISVILLE;KY;40291 KENTON;CITY COMMISSIONER (J);COVINGTON-KENTON;N/A;JERRY;;STRICKER;;ONE RIVERSIDE DRIVE #501;;COVINGTON;KY;41011 SECRETARY OF STATE;STATE REPRESENTATIVE;43RD DISTRICT;DEMOCRAT;H. KEVIN;;EDDINS;;426 PENNINGTON LANE;;LOUISVILLE;KY;40207 SECRETARY OF STATE;STATE REPRESENTATIVE;50TH DISTRICT;REPUBLICAN;DAVID;;FLOYD;;102 MAYWOOD AVENUE;;BARDSTOWN;KY;40004 SECRETARY OF STATE;STATE REPRESENTATIVE;65TH DISTRICT;REPUBLICAN;CRAIG;T.;BOHMAN;;12 EAST 26TH STREET;;COVINGTON;KY;41014 SECRETARY OF STATE;STATE REPRESENTATIVE;85TH DISTRICT;REPUBLICAN;TOMMY;;TURNER;;175 CLIFTY GROVE CHURCH ROAD;;SOMERSET;KY;42501 SECRETARY OF STATE;STATE REPRESENTATIVE;88TH DISTRICT;REPUBLICAN;WILLIAM;P.;FARMER;JR.;3361 SQUIRE OAK DRIVE;;LEXINGTON;KY;40515 SECRETARY OF STATE;STATE SENATOR;11TH DISTRICT;REPUBLICAN;RICHARD;L. "DICK";ROEDING;;2534 KEARNEY COURT;;LAKESIDE PARK;KY;41017 SECRETARY OF STATE;STATE SENATOR;11TH DISTRICT;REPUBLICAN;CHARLIE;;WALTON;;1663 BRIERWOOD COURT;;FLORENCE;KY;41042 SECRETARY OF STATE;STATE SENATOR;13TH DISTRICT;DEMOCRAT;ERNESTO;;SCORSONE;;511 WEST SHORT STREET;;LEXINGTON;KY;40507 SECRETARY OF STATE;STATE SENATOR;15TH DISTRICT;REPUBLICAN;VERNIE;;MCGAHA;;4787 WEST HIGHWAY 76;;RUSSELL SPRINGS;KY;42642 SECRETARY OF STATE;STATE SENATOR;17TH DISTRICT;DEMOCRAT;CLIFFORD;M.;WALLACE;;311 KY 36 WEST;;WILLIAMSTOWN;KY;41097 SECRETARY OF STATE;STATE SENATOR;19TH DISTRICT;DEMOCRAT;TIM;;SHAUGHNESSY;;9502 ELK HILL COURT;;LOUISVILLE;KY;40202 SECRETARY OF STATE;STATE SENATOR;1ST DISTRICT;DEMOCRAT;ROBERT;L.;JACKSON;;PO BOX 1111;;MURRAY;KY;42071 SECRETARY OF STATE;STATE SENATOR;21ST DISTRICT;REPUBLICAN;ALBERT;L.;ROBINSON;;1249 SOUTH MAIN STREET;;LONDON;KY;40741 SECRETARY OF STATE;STATE SENATOR;23RD DISTRICT;DEMOCRAT;TIMOTHY;J.;QUIGLEY;;2392 CRESTBROOK DRIVE;;CRESCENT SPRINGS;KY;41017 SECRETARY OF STATE;STATE SENATOR;23RD DISTRICT;REPUBLICAN;JACK;;WESTWOOD;;36 FOREST AVENUE;;ERLANGER;KY;41018 SECRETARY OF STATE;STATE SENATOR;25TH DISTRICT;REPUBLICAN;ROBERT;;STIVERS;;137 LOCUST STREET;;MANCHESTER;KY;40962 SECRETARY OF STATE;STATE SENATOR;27TH DISTRICT;DEMOCRAT;WALTER;"DOC";BLEVINS;;PO BOX 604;;WEST LIBERTY;KY;41472 SECRETARY OF STATE;STATE SENATOR;29TH DISTRICT;DEMOCRAT;JOHNNY;RAY;TURNER;;ROUTE 122, BOX 5;;DRIFT;KY;41619 SECRETARY OF STATE;STATE SENATOR;31ST DISTRICT;DEMOCRAT;RAY;S.;JONES;II;PO BOX 1378;;PIKEVILLE;KY;41502 SECRETARY OF STATE;STATE SENATOR;33RD DISTRICT;DEMOCRAT;GERALD;A.;NEAL;;4711 BREWSTER AVENUE;;LOUISVILLE;KY;40211 SECRETARY OF STATE;STATE SENATOR;37TH DISTRICT;DEMOCRAT;LARRY;;SAUNDERS;;736 PALATKA ROAD;;LOUISVILLE;KY;40214 SECRETARY OF STATE;STATE SENATOR;3RD DISTRICT;DEMOCRAT;JOEY;;PENDLETON;;905 HURST DRIVE;;HOPKINSVILLE;KY;42240 SECRETARY OF STATE;STATE SENATOR;5TH DISTRICT;REPUBLICAN;VIRGIL;;MOORE;;241 MOORE ROAD;;LEITCHFIELD;KY;42754 SECRETARY OF STATE;STATE SENATOR;7TH DISTRICT;REPUBLICAN;LINDY;;CASEBIER;;3304 HARDWOOD FOREST;;LOUISVILLE;KY;40214 SECRETARY OF STATE;STATE SENATOR;9TH DISTRICT;REPUBLICAN;RICHARD;A.;SANDERS;JR.;901 MAPLE LEAF;;FRANKLIN;KY;42134 30 rows selected. SQL> spool off