DianaPatel

• Jul 30th, 2007

 

Circular Joins or loops occur when say a table A is joined to table B and table B is joined to table C which is inturn joined to table A. So if the report just needs the columns from table A and table C, you cannot be sure what join it would take i.e A--B--C or the A--C. Hence the loops should be generally avoided.

There are two common ways of avoiding loops.

1) create an alias. in the above example...create an alias of table A, i.e A1 which can be joined to table C.

2) creating filters is possible. This filter needs to be created in tables A and C.