How to query two databases with the same structure at one time?

mephistox

How to query two databases with the same structure at one time?

waxiaoning

Do view

waxiaoning

select * from a.dbo.tablename
union all select * from b.dbo.tablename

terran1208

union or union all

mephistox

Thank you