Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Query puzzler
I've got a fairly complex query - which runs fine:
(sorry about pasting the entire thing, but I'm baffled
by what's happening)
SELECT A.MASTER_PERSON_ID PERSON_ENSITE_ID, A.MASTER_PERSON_PREFIX_CODE PREFIX_ID, A.MASTER_PERSON_FIRST_NAME PERSON_FIRST_NAME, A.MASTER_PERSON_MIDDLE_INITIAL PERSON_MID_INITIAL,A.MASTER_PERSON_LAST_NAME PERSON_LAST_NAME, A.MASTER_PERSON_SUFFIX_CODE SUFFIX_ID,
A.TITLE_CODE TITLE_ID, A.PERSON_TYPE_CODE PERSON_TYPE_ID, B.ADDRESS_OR_PHONE WORK_PHONE, C.ADDRESS_OR_PHONE HOME_PHONE, D.ADDRESS_OR_PHONE EMAIL, G.PHYSICAL_ADDRESS_LINE_1 P_ADDR_1, G.PHYSICAL_ADDRESS_LINE_2 P_ADDR_2, G.PHYSICAL_ADDRESS_LINE_3 P_ADDR_3, G.PHYSICAL_ADDRESS_MUNICIPALITY P_CITY, G.PHYSICAL_ADDRESS_STATE_CODE P_STATE_ID, G.PHYSICAL_ADDRESS_ZIP P_ZIP, G.MAILING_ADDRESS_LINE_1 M_ADDR_1, G.MAILING_ADDRESS_LINE_2 M_ADDR_2, G.MAILING_ADDRESS_LINE_3 M_ADDR_3, G.MAILING_ADDRESS_MUNICIPALITY M_CITY, G.MAILING_ADDRESS_STATE_CODE M_STATE_ID, G.MAILING_ADDRESS_ZIP M_ZIP, A.START_DATE PERSON_START_DATE, A.END_DATE PERSON_END_DATE
Thanks,
Harry Boswell
Received on Fri Dec 28 2001 - 11:41:59 CST