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?
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.