Skip to Content
avatar image
Former Member

how to resolve this loop

hello gurus,

                  here i have one requirement , that is how to solve a loop by using alias ..please go through attached file

SCN.jpg (25.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 12, 2015 at 06:56 PM

    Hi

    instead of alias just remove the joins between A to C and B to D.After that no loop.Or if there is need of to pull data from A,C & B,D without joining other table then create the shortcut join between A,C & B,D.

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 12, 2015 at 06:59 PM

    Hi,

    Create alias like shown in image.

    Here I have created Alias for B & D table to resolve the loop

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 18, 2015 at 12:13 PM

    Alla,

    Previous answers may be correct or wrong. We don't know.

    What are the cardinalities between the tables? Without knowing that, we cannot help you.

    The only thing that looks logical is that you could use a shortcut join for A to C but even that is a doubt without knowing what the tables represent and the cardinalities between them.

    Please can you provide more information?

    If it's an interview question, then you simply haven't got enough information to work with - ask for more.

    Regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded