3 Replies Latest reply on Dec 28, 2016 11:25 AM by Alexander Mou

    Right and Full outer joins are disabled in Tableau 10 with cross data join



      I'm doing cross data join between two different DB tables coming from Oracle.

      I need all the records from both the tables. I can simply do a full outer using custom sql if both the tables are from same database. But the case here is different. Each table is coming from two different Oracle instances.

      After i pull the tables and click on join type...right outer and full outer join is disabled . How to achieve this? What might be the issue?


      Also I've tried with Table A left outer join Table B and Table B left outer join Table A, hoping I can do a full outer join between the tables this way, but not able to make it work

      Please share your thoughts.


      Thank you