Hi guys.
I have an annoying problem when I try to make an appointment at the bank. Our version is the most up-to-date Oracle Database 12c R@elease 12.2.0.1.0
I researched the forum but found no approaches on the subject.
What happens?
I'm doing a query that has a LEFT JOIN with the following form:
LEFT JOIN
view_materialized.table@databaseLink
ON
TB1.ID = TB2.ID
AND TB1.ID2 = TB2.ID2)
The result for this query is:
01417. 00000 - "a table may be extra joined to at most one other table"
* Cause: a.b = b.b and a.c = c.c is not allowed
* Action: Check that this is really what you want, then join b and c first
in a view
It turns out that when I substi- tute the LEFT by INNER the result appears normally.
I noticed that the difference between them are some records with NULL values, but we need the NULL's to appear in the listing since the result of the same populates a dashboard in OBIEE.
can you help me?
Thank you.