Compare two database with 3 output

[Anonymous]

Hello,

I try to compare two tables. But I can't find a solution.
The problem :
I work on MSSQL.
I want to list all of tables on DB. Request is :

select table_name from INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE'

Next I want compare the results. But with Tmap and look up doesn't work.
In fact I would like 3 results :
- File csv with the list of table which exist both.
- File csv with the list of table which not exist on DB 1
- File csv with the list of table which not exist on DB 2
For the moment, my result is a file with list of table which exist both.
I don't know what to do anymore.
Thank's in advance,

My job :

[vapukov]

You can use combination of 2 lookups (check also settings on pictures):
                  

[Anonymous]

Thank !!!!!
That works!!!