join multiple sql server databases in one database

I have multiple sql server databases and want a script to join them all together in same db