I have a core query with a simple join that works great:

```
SELECT 
     TableA.JobType, 
     TableA.AssignedTech, 
     TableB.EmpNumber, 
     TableB.EmpFirstName, 
FROM 
     TableA, TableB
WHERE 
     TableA.AssignedTech=TableB.EmpNumber

```

I need to JOIN a third table to get access to a field in a third table. 

```
SELECT 
     TableA.JobType, 
     TableA.AssignedTech, 
     TableB.EmpNumber, 
     TableB.EmpFirstName, 
     images.image 
FROM 
     TableA, TableB, images 
WHERE 
     TableA.AssignedTech=TableB.EmpNumber
AND 
     TableA.AssignedTech=images.empno

```

This is fine UNLESS there is no relationship for: "TableA.AssignedTech=images.empno" at which point the record is not returned.

I need to display ALL records from my core query and append the images.empno if it is available.