I am trying to pull all data from SQL Database A, Table 1 where column name is X, and the value in column X equals the value in Database B, Table 2, column name Y.
So I have 2 databases on the same server.
One named A, the other named B.
I need to get all the data from A, Table1, where the values of Column Name X are equal to the values in in Column Name Y in B, Table2, and insert/write them to a new table in Database B.
Any and all help is appreciated. My SQL writing skills are very sub par.
If the title, and the subject differ, I apologize. I am just trying to put the thought thru my head as I write.