AnsweredAssumed Answered

How do I join two tables in two different databases?

Question asked by SBC_7 on Jul 26, 2012
Latest reply on Jul 26, 2012 by mike_aronson
Can I use one database connector that connects to one database (DW) but the select statement has a join to another table in another database (STAGE). Here is the sql query. Is this possible and if so could you please guide me? Thanks.

Suresh

SELECT DISTINCT COL1,COL2,COL3

FROM [DW].[dbo].[NP_PROD_DIM] DIM

INNER JOIN [STAGE].[MARA_GENERAL_MATERIAL_DATA] MARA ON DIM.MAT_NUM=MARA.MATERIAL_MATNR

Outcomes