I can't figure this out.
I have two tables in two different dbs, they are not alike at all but do have one column that is the same.
Table A contains all users in the company.
Table B contains users that have access to an application.
I want to get the list of users from Table A that do not exist in Table B.
Should I be using Union or Joins?
Thanks in advance.