lines which are not collabrated

[razyorazyo]

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