Hi all.
I'm pretty familiar with LEFT JOIN, but this probably isn't that.

I have two tables, tblJOBS and tblEMPLOYEES.
tblJOBS is all about the jobs, and has one column (EMPLOYEE_ID) that links an employee in tblEmployees to a given job.
Ordinarily, I would select columns from both tables in a left join (from tblJOBS LEFT JOIN tblEMPLOYEES) to build the recordset I need.

As I understand LEFT JOIN, I will still get the records from tblJOBS even if there is no value in Employee_ID.

But I also need a record in the table if there happens to be an employee in tblEMPLOYEES who is not linked to a job in tblJOBS.
That row of data would have blanks for all the tblJOBS fields and information for all the tblEMPLOYEES fields.

Is there come kind of fancy join that makes this result?
Thanks.