[Solved] Select from 2 database remove same column

You could try something like:

SELECT ci_name
FROM appwarehouse.ci_table
WHERE ci_name NOT IN
  (SELECT affected_ci FROM sitequota.incidents
  )