Need to filter data using two tables in a script

[#1]

I have two tables one employees and the other departments. I have used these with others to get what I want and filtered the department table. There is however no way I can filter the employee table on it's own. If I link it to the department table in the script then I can use the description fiels as I already do for the department table.

question is what syntax do I need ot use to pull the data from both tables in the script, there is of course a field called department in each table to connect them.

[#2]

tblEmployees:

LOAD

EmpID,

EmpName,

DeptID;

SQL SELECT *

FROM tblEmployees;

Left join (tblEmployees)

LOAD

DeptID,

DeptName;

SQL SELECT *

FROM tblDept;

[#3]

Thanks for that, I had to reverse my tables around though so the department is used with the left join to remove the unwanted entries.