I have two tables which I need to join/merge and I dont know how.
My table is strcutured as follows:
ID = Luke, Hans, ObiWan
Budget = 1,2,3
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