Fill empty values in table, based on another table
I have a table, in which certain values are missing. In this case, the Oracle Employee Numbers are missing.
What I would like to do is fill these empty Oracle Employee ID values in my base table (which contains SAP Project and SAP_Employee). The Oracle Employee numbers are in another table and the link between the two tables is the field SAP employee.
I've tried left/right/outer/inner joins etc - but feel like I'm missing something.