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
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
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