4 Replies Latest reply on Dec 21, 2014 12:12 PM by Łukasz Majewski

    Union All from two data source .

    Erez Mizrahi

      I have two databases for employee salary.

      One database based install on Microsoft and the second database is ORACLE.

      They are installed on two physically different computers.

      The employee's salary consists date from the two database, but it could be a situation that only one database have record in given date.

      (Only one record  from one database)

      I need to show the full employee salary from the two databases

      I Try to use Custom SQL and fail .

      I tried to work with Date Relationship but in a situation that the main database don't have record no data is loaded.

       

      Thanks Erez