2 Replies Latest reply: Jan 4, 2013 12:19 PM by jagan mohan rao appala RSS

    Joining/Merging Tables

      I have two tables which I need to join/merge and I dont know how.

       

      My table is strcutured as follows:

       

      BudgetData:

      Load

         EmployeeID

         Budget

      From...

       

      example

      ID = Luke, Hans, ObiWan

      Budget = 1,2,3

       

      ActualData:

      Load

         EmployeeID

         Actual

      From...

       

      example

      ID = Luke, Hans, Yoda

      Actual = 4,5,6

       

      My problem is that whilst most employees have both actuals and budgets, some employees just have a budget and no actuals, and some have actuals and no budget. I can I get the below table which has it all

       

      Budget+ActualData

      ID = Luke, Hans, ObiWan, Yoda

      Budget = 1, 2, 3, 0

      Actual = 4, 5, 0, 6

       

      Any help most appreciated.

       

      Thanks