I am facing the problem where I have three tables:
First table has data like:
A B C D
1 2 3 4
1 2 3 5
Second table has data like:
D E
4 x
6 y
Third table has data like:
E F
x result1
y result2
What i need is a Query that displays all Values from the first table (obviously a left outer join) and if available the combination of the second and third table.
So the result would look somewhat like this:
A B C D E F
1 2 3 4 x result 1
1 2 3 5
However I cannot get a solution on this.
I already tried left joining two times (results in an error as it is not allowed in opensql) and inner joining the second and third table and trying to right join the first table (also not allowed in opensql).
How do I realize my desired result-table?