Is it possible when i want to join data from 2 databases?

Question

i have a question i have db_1 and db_2 where on db_1 i have one table named tb_name and have two fields nim and name. on db_2 i have one table again named tb_address and have two fields nim and address... how it could be??

Hariharasudhan Chandramurthy · Answer

Yes We can. Make sure to mention the table name with DatabaseName.SchemaName.TableName Example: select first.* second.* from db_1.dbo.tb_name first join db_2.dbo.tb_address second on first.addressid = second.addressid Happy Coding...

Hariharasudhan Chandramurthy · Answer

If you feel the answer resolves your issue please accept my answer.. Thanks

Dwi Hyuga · Answer

thank!!!