Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    1

    Unanswered: Reducing the number of tables to not more than 4

    Hi all,

    In the below query, 5 tables are used. I want to replace this query with any number of Select statements with only restriction of NOT MORE THAN 4 TABLES can be used in a single select statement.

    Can any one help me in this ? Pls...

    My ID is newmoonera@gmail.com. If possible, email me... Thanks alot...

    SELECT
    BPID.SYIN_REF_ID
    , BPID.CKPY_REF_ID
    , BPID.BPID_CK_NO
    , BPID.BPID_TYPE
    , BPID.LOBD_ID
    , BPID.LOBD_NAME
    , BPID.CKPY_PAYEE_TYPE
    , BPID.BPID_PAYEE_ID
    , BPID.BPID_PAYEE_TAX_ID
    , BPID.CKCK_PAYEE_NAME
    , BPID.CKPY_NET_AMT
    , BPID.CKCK_SEQ_NO
    , PAYM.PAY_TYPE
    FROM
    CMC_BPID_INDIC BPID
    , EXT_CKPR_BPID_GROUP GRUP
    , EXT_CKEN_EFT_ENR ENRL
    , EXT_CKPR_PROV_EXCEPTIONS EXCP
    , EXT_CKPR_PAYMENT_TYPE PAYM
    WHERE
    BPID.BPID_PAYEE_ID *= ENRL.PRPR_ID
    AND BPID.BPID_PAYEE_ID *= EXCP.PRPR_ID
    AND EXCP.PAY_PRINT_IND = 'NOPAY'
    AND BPID.BPID_TYPE = GRUP.BPID_TYPE
    AND GRUP.PAY_TYPE = PAYM.PAY_TYPE

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Why do you want to reduce this to just 4 tables?

    Putting your email in a public forum is likely to attract spam - if people feel desperate to do your coursework for you then they could contact you either through a PM or by an internal email by just clicking on your user name.

    Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •