Forum Discussion
DiKi-I
Post Partisan
Post PartisanPower query help
Hi , I have multiple relationship table around 5 to 6 which are available in mutiple tables. I'm attaching some sample data there are 3 tables table1, table2, table3. Realtionship is from parent...
spinfuzer
Solution Sage
Solution Sagesee latest post
DiKi-II tried with only two tables initially but its not loading and taking forever.
There is no circular dependency (A->B)
There are around 2k records- spinfuzer
Are you sure you are referring to the right columns in the join and not inadvertantly going from A --> A --> A--> A in an infinite loop instead of A --> B?
I added 500 random records and it ran just fine. Do you have a larger data sample?
- DiKi-I
Hi
I checked the data the classname is different but in some cases the parent and child will be same.
For those entries I am getting many rows.
Hierarachy can be same for some records.
- spinfuzer
see latest reply