Chuck wrote:
>
> SELECT
> ACACCTCATX."ACTIVITY", ACACCTCATX."ACCT_CATEGORY",
> ACACCTCATX."ACCT_CAT_CLASS",
> ACLEVEL."POSTING_FLAG",
> ACACCTCLSS."DESCRIPTION",
> ACACTIVITY."ACTIVITY", ACACTIVITY."DESCRIPTION",
> ACBUDDTLX."FISCAL_YEAR", ACBUDDTLX."PERIOD", ACBUDDTLX."AMOUNT",
> ACTRANS."TRAN_AMOUNT", ACTRANS."PERIOD", ACTRANS."FISCAL_YEAR"
> FROM
> "LAWDEV"."ACACCTCATX" ACACCTCATX,
> "LAWDEV"."ACLEVEL" ACLEVEL,
> "LAWDEV"."ACACCTCLSS" ACACCTCLSS,
> "LAWDEV"."ACMASTERX" ACMASTERX,
> "LAWDEV"."ACACTIVITY" ACACTIVITY,
> "LAWDEV"."ACBUDDTLX" ACBUDDTLX,
> "LAWDEV"."ACTRANS" ACTRANS
> WHERE
> ACACCTCATX."ACTIVITY_GRP" = ACLEVEL."ACTIVITY_GRP" AND
> ACACCTCATX."ACTIVITY" = ACLEVEL."ACTIVITY" AND
> ACACCTCATX."ACCT_CAT_CLASS" = ACACCTCLSS."ACCT_CAT_CLASS" AND
> ACACCTCATX."ACTIVITY" = ACMASTERX."ACTIVITY" AND
> ACACCTCATX."ACCT_CATEGORY" = ACMASTERX."ACCT_CATEGORY" AND
> ACACCTCATX."ACTIVITY" = ACACTIVITY."ACTIVITY" AND
> ACMASTERX."ACTIVITY" = ACBUDDTLX."ACTIVITY" AND
> ACMASTERX."ACCT_CATEGORY" = ACBUDDTLX."ACCT_CATEGORY" AND
> ACMASTERX."ACTIVITY" = ACTRANS."ACTIVITY" AND
> ACMASTERX."ACCT_CATEGORY" = ACTRANS."ACCT_CATEGORY" AND
> ACLEVEL."POSTING_FLAG" = 'P' AND
> ACTRANS."FISCAL_YEAR" = 1999. AND
> ACBUDDTLX."PERIOD" >= 1. AND
> ACBUDDTLX."PERIOD" <= 10. AND
> (ACACCTCATX."ACTIVITY" = '01995-01-01' OR
> ACACCTCATX."ACTIVITY" = '01596-19-05')
> ORDER BY
> ACACCTCATX."ACCT_CAT_CLASS" ASC,
> ACACCTCLSS."DESCRIPTION" ASC
I think that you can remove the table 'ACMASTERX' and go with:
[I removed AC in front of the table names]
CTCATX."TIVITY_GRP" = LEVEL."TIVITY_GRP" AND
CTCATX."TIVITY" = LEVEL."TIVITY" AND
CTCATX."CT_CAT_CLASS" = CTCLSS."CT_CAT_CLASS" AND
CTCATX."TIVITY" = TIVITY."TIVITY" AND
CTCATX."TIVITY" = BUDDTLX."TIVITY" AND
CTCATX."CT_CATEGORY" = BUDDTLX."CT_CATEGORY" AND
CTCATX."TIVITY" = TRANS."TIVITY" AND
CTCATX."CT_CATEGORY" = TRANS."CT_CATEGORY" AND
LEVEL."POSTING_FLAG" = 'P' AND
TRANS."FISCAL_YEAR" = 1999. AND
BUDDTLX."PERIOD" >= 1. AND
BUDDTLX."PERIOD" <= 10. AND
(CTCATX."TIVITY" = '01995-01-01' OR CTCATX."TIVITY" = '01596-19-05')
> Here are the number of rows in each of the tables:
>
> ACACCTCATX=4389
> ACLEVEL=72
> ACACCTCLSS=55
> ACMASTERX=73
> ACACTIVITY=72
> ACBUDDTLX=7882
> ACTRANS=141
Christophe
Christophe L. Galerne cgalerne_at_tumbleweed.com
Software Engineer Tel: (650) 216 2029
"Someday we'll all look back at this and laugh..."
Received on Wed Nov 10 1999 - 18:05:41 CST
