Select query from two databases
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.
I'm thinking maybe a nested query?
SELECT * FROM database_1.table_a WHERE user NOT IN (
SELECT user FROM database_2.table_b
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
thanks nogdog, that did it.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread