lines which are not collabrated

razyorazyo — Wed, 16 Sep 2015 11:17:31 GMT

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:

second table:

third table:

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

topic lines which are not collabrated in QlikView