How to merge informations from two databases by the SQL/T-SQL

Question

I have two databases with stock info. Both of them (among others) contains:

SKU;stock_level

What I want to get is:

SKU;stock_level_warehouse1;stock_level_warehouse2

The SKU's are the same at every warehouse, only stock level could be different. How can I merge data from that two databases by the SQL/T-SQL?

EDIT (Sample Data)

SELECT
    MSSERVER.company1.dbo.vwArticles.article_sku, 
    MSSERVER.company1.dbo.vwArticles.warehouse_id, 
    MSSERVER.company1.dbo.vwArticles.stock_level
FROM
    MSSERVER.company1.dbo.vwArticles
WHERE
    MSSERVER.company1.dbo.vwArticles.warehouse_id = 1

In the second query (that I want merge with this above) everything is the same except company name - there is "company2" instead "company1".

As the result I want to get:

SKU;STOCK_LEVEL_COMAPNY_1;STOCK_LEVEL_COMPANY_2

Do you mean you have two _tables_, or do you really have two tables in two different _databases_? Also, if you're not using MySQL, then please remove that tag. — Tim Biegeleisen, May 08 '17 at 08:53
Nope, I mean two databases exactly. Right - MySQL tag removed :) — mrdd, May 08 '17 at 08:58
Help for the select from two databases part: http://stackoverflow.com/questions/1144051/selecting-data-from-two-different-servers-in-sql-server — Tim Biegeleisen, May 08 '17 at 08:59

score 0 · Answer 1 · answered May 08 '17 at 08:55

0

Without sample data I cannot be certain but you just need to JOIN your tables.

SELECT t1.SKU, t1.stock_level_warehouse1, t2.stock_level_warehouse2
FROM yourtable1 t1
INNER JOIN yourtable2 t2 ON t1.SKU = t2.SKU

answered May 08 '17 at 08:55

Matt

14,906
27
99
149

1

its from same DB i guess. but the question is looking for 2 different DB merge. – Biswabid May 08 '17 at 08:59
Yep. It's the same MS SQL server but two different databases there. – mrdd May 08 '17 at 09:06
I provided some sample data at the first post. – mrdd May 08 '17 at 09:30

score 0 · Accepted Answer · answered May 08 '17 at 09:39

0

Assuming your two databases are in the same server: Database 1: FooDB Database 2 : FooDB2

select t1.id, t2.descr
from [foodb].[dbo].table1 t1
inner join [foodb2].[dbo].table2 t2
on t1.id = t2.table1id

answered May 08 '17 at 09:39

Alkis Giamalis

300
7
14

How to merge informations from two databases by the SQL/T-SQL

2 Answers2