SQL LEFT JOIN

  SQLEmployees := 'SELECT E.*, D.* ' +
    'FROM tblEmployees AS E ' +
    'LEFT JOIN tblDepartments AS D ' +
    'ON E.ADepartmentID = D.ADepartmentID ' +
    'ORDER BY D.AIndex, E.AIndex ASC';