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.
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