Table Not Found when using left join

[#1]

Tab1

$(qvd_name)

: Load

[ID Number] ,
[Department Name]

from  

QVD\Layer 2\T_Department.qvd](

qvd)

Tab 2

left join

NoConcatenate
[table 2]

LOAD
[ID Number] ,
[Hiire Date]
FROM
(qvd)

Where [Hire Date] >0;

[Employee Rec]

Load

[ID Number],

max(Hire Date]) as [Date Hire]

Resident

[table 3]:]:
load
[ID Number] ,
max(s483_Dt) as [483 Dt],
max(s324_Dt) as [324 Dt],
max(s367_Dt) as [367 Dt]
Resident  [tabe 2]
Group by [ID Number];

drop Table [table 2];

STORE

$(qvd_name)  into $(qvd_layer_3_path) $(qvd_name).qvd (qvd);

In this example table 1 is the source table.  Table 2 has a common field called ID

[MK_QSL]

Left Join and NoConcatenate ?

Remove NoConcatenate !!

Also,when you are using Max([Hire Date]), you need to group by ID Number....

Provide your exact error...