How do i get rid of irrelevent rows in SQLite and JAVA

I am trying to get the information from my DB in SQLite, I have many kinds of employees with all the same attributes but i have a manager which has a special field, i`m trying to join both of the tables (Employees , ShiftManager) so each employee has the special field as null, when if the employee is a manager it will contain the respective data. I tried all kind of inner joins, Outer Joins but i keep getting duplicates. (i have in both table ID as primary key so i would like to join them based on the key)

I Highly appreciate your help, I tried looking it up on google for 2 hours now so i would not hurt my rep here but i`m lost. thanks a lot.