Full outer join in TT

Issue

This Content is from Stack Overflow. Question asked by Jakub Znamenáček

I am quite new to SQL so maybe this is very basic question, but I was not able to find answer on it. I am trying to get full outer join in TimesTen DB, but I do not know how should the query look like.

I have tried something like this:

select t1.column1, t2.column2 from table1 t1 full outer join table2 t2 on t1.column1 = t2.column2;

but this works in oracle but when I run it against TimesTen it throws an error, that there is problem before “full”.
Any idea how this can be solved?



Solution

This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.

This Question and Answer are collected from stackoverflow and tested by JTuto community, is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.

people found this article helpful. What about you?