RIGHT OUTER JOIN
-
Hi All, I am trying to debug a data issue, where in a query is reporting incorrect data. Upon looking at the query having about 15 tables joined in the query, there is one join where it is specified as RIGHT OUTER JOIN but does not have a table it joins to. I am researching an existing query, written by someone else with no documentation. I tried to add one join at a time to debug this issue, but the query fails when i try to add the RIGHT OUTER JOIN with no table to join on specified. I really don't know how the original query is working. any ideas/inputs much appreciated!! Thanks!
-
Hi All, I am trying to debug a data issue, where in a query is reporting incorrect data. Upon looking at the query having about 15 tables joined in the query, there is one join where it is specified as RIGHT OUTER JOIN but does not have a table it joins to. I am researching an existing query, written by someone else with no documentation. I tried to add one join at a time to debug this issue, but the query fails when i try to add the RIGHT OUTER JOIN with no table to join on specified. I really don't know how the original query is working. any ideas/inputs much appreciated!! Thanks!
-
Hi All, I am trying to debug a data issue, where in a query is reporting incorrect data. Upon looking at the query having about 15 tables joined in the query, there is one join where it is specified as RIGHT OUTER JOIN but does not have a table it joins to. I am researching an existing query, written by someone else with no documentation. I tried to add one join at a time to debug this issue, but the query fails when i try to add the RIGHT OUTER JOIN with no table to join on specified. I really don't know how the original query is working. any ideas/inputs much appreciated!! Thanks!
Hi, Maybe that table was dropped or renamed?