I'm having some trouble re-writing these JOINS using explicit joins. I'm trying to understand how this is accomplished. Here is the original query using implicit joins that I've inherited:
FROM prod.f31122 t, prod.f4801 wo, prod.f30008 r, prod.f0101 ab WHERE t.wtdoco = wo.wadoco(+) and t.wtmmcu = wo.wammcu(+) and t.wtmmcu = r.iwmcu and t.wtan8 = ab.aban8
I've tried the following, but I'm getting different result sets. The same count, but the result set is incorrect (likely an issue with my groupings which aren't displayed). Here is my translation using explicit joins:
FROM prod.f31122 t JOIN prod.f4801 wo ON t.wtdoco = wo.wadoco JOIN prod.f4801 wo ON wo.wammcu = t.wtmmcu JOIN prod.f30008 r ON t.wtmmcu = r.iwmcu JOIN prod.f0101 ab ON t.wtan8 = ab.aban8
I just want to make sure that my translation from implicit joins to explicit joins is logically correct (for my education and understanding). For the record, I can keep the implicit joins, but I am just trying to understand this process better.