Syntax error, Table Not Found

[#1]

Hi Again

Please see the following script, it gives me a

Table not found

TotalHoursWorked:

Left Join  (FieldStaff)

LOAD   

   Linkedto as FieldStaffNoJoin,

   ShiftLengthExMB AS TotalHoursWorked

Resident TotalHoursWorkedTable

ERROR

I'm very new to Qlikview, but need to load some data (I want to do a Sum() of the ShiftLengthExMB column, but just trying to get the concept of how to load the QVD data, join to it, and add a column from that table to my main (Fieldstaff) table.

//Load FieldStaff Table

FieldStaff:
LOAD  employeenumberas [FieldStaffNoJoin],
surname as [Surname],
givennames as [GivenNames],

................................

(SysPrefix & employeenumber) as [FieldStaffNo];

SQL Select e.employeenumber,
  e.surname,
  e.givennames,
  ...............
From  $(vDB2)employee E;

// Now I want to load some data from a QVD file

TotalHoursWorkedTable:

Left Join  (FieldStaff)
LOAD
     ShiftLengthExMB,
     FieldStaffNo
FROM

(qvd);

TotalHoursWorked:
Left Join  (FieldStaff)
LOAD   
   Linkedto as FieldStaffNoJoin,
   ShiftLengthExMB AS TotalHoursWorked
Resident TotalHoursWorkedTable;
Drop Table  TotalHoursWorkedTable;