Hi all,
I have a question, how can I show lines that are exist in one table and do not exist on the other table.
example:
first table:
factory | worker id | lic kod |
1 | 1 | 1 |
1 | 1 | 2 |
1 | 2 | 1 |
second table:
factory | lic id | dep_kod |
1 | 1 | 1 |
1 | 2 | 1 |
third table:
factory | dep_kod | worker id |
1 | 1 | 1 |
1 | 1 | 2 |
I want to create a table which will present the next data :
factory | dep_kod | worker id | lic kod |
1 | 1 | 2 | 2 |
worker_id 2 is not connected to LIC__KOD 2 .
worker_id 2 is connected to dep 1 which is connected to lic cod 2.
thank you