Help with joining 3rd table

[Mario1011]

Please could you assist with table join:

FACT

Budget:
LOAD 
     [Position ID],
     [Cost Centre],
     Budget as Amount,
     'Budget' as Type,
     'Budgeted'as [Wage Type Text],
      Date,
      [Position ID]&[Cost Centre] as PositionKey
FROM

Table1, Source1

JOIN
Actuals:
LOAD [Cost Center] as [Cost Centre],
    Employee,
     Name1, 
     [Wage Type Text],
     [Posting Date] as "Date", 
     Amount,
     'Actuals' as Type,
     Position as [Position ID],
     Position&[Cost Center] as PositionKey
FROM

Table2, Source1

I need to join this table to create a single Fact Table  but only have  'Employee' and data for 1 month as the table is overwritten daily

LOAD Employee,
     Date,
     Annual_Balance_NoBooking,
     Daily_Hours,
     AL_Liability as Amount, 
     'Leave Balance' as Type,
     'Leave Balance'as [Wage Type Text]
     FTE
FROMSource 3

[Vegar]

What about  joining the  3rd tables you did with no 2?  

Load ... From Table1;

Join Load ... From Table2;

Join Load ... From Table3;

If it is not possible then please explain what issue you are facing by doing so.