If i decided to go for alias to resolve my loop

[system]

Hi All,

I knew that there is no thumb rule to resolve loops using alias or context.

If i decided to go for alias approch how can i identify which table should be my alias .

if table b if i selcted why ? and why not table a.

thanks

---

rao_marapatla (BOB member since 2008-08-06)

[system]

@rao_marapatla

I knew that there is no thumb rule to resolve loops using alias or context.

Yes, actually, there is.

If i decided to go for alias approch how can i identify which table should be my alias .

Start here:
Sticky: Read Me: Best Way to Resolve Loops Context? Alias?
Then here:
Context Versus Alias Overview (blog post)

---

Dave Rathbun (BOB member since 2002-06-06)