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

    lakshminarayana.m

      Hi,

      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