Are the columns added to the SELECT clause or the WHERE clause?
<hboswel1_at_bellsouth.net> wrote in message
news:3c2cae15.98363659_at_news1.lig.bellsouth.net...
> 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,
> E.MASTER_AI_NAME PERSON_COMPANY,
> F.RELATIONSHIP_CODE RELATIONSHIP_TYPE_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
> FROM PERSON A, PERSON_TELECOM B, PERSON_TELECOM C, PERSON_TELECOM D,
> AGENCY_INTEREST E, AGENCY_INTEREST_PERSON_XREF F, PERSON_ADDRESS G
> WHERE (( B.TELECOM_TYPE_CODE = 'wp') AND
> (A.MASTER_PERSON_ID = B.MASTER_PERSON_ID) AND
> (A.INT_DOC_ID = B.INT_DOC_ID) ) AND
> (( C.TELECOM_TYPE_CODE = 'hp') AND
> (A.MASTER_PERSON_ID = C.MASTER_PERSON_ID) AND
> (A.INT_DOC_ID = C.INT_DOC_ID) ) AND
> (( D.TELECOM_TYPE_CODE = 'em') AND
> (A.MASTER_PERSON_ID = D.MASTER_PERSON_ID) AND
> (A.INT_DOC_ID = D.INT_DOC_ID) ) AND
> (A.MASTER_PERSON_ID = F.MASTER_PERSON_ID) AND
> (A.INT_DOC_ID = F.INT_DOC_ID) AND
> (E.MASTER_AI_ID = E.MASTER_AI_ID) AND
> (E.INT_DOC_ID = F.INT_DOC_ID) AND
> ( (A.MASTER_PERSON_ID = G.MASTER_PERSON_ID) AND
> (A.INT_DOC_ID = G.INT_DOC_ID) )
>
>
> As I said, this runs fine. But if I add two more columns from
> the PERSON table, it wanders off into Limbo Land and never
> completes (never == runs at least 1 1/2 hours with no response).
> What would adding two more columns possibly do to blow this out of
> the water?
>
> Thanks,
> Harry Boswell
>
Received on Fri Dec 28 2001 - 15:06:51 CST
