I can successfully query the same table in multiple databases as follows:

```
DECLARE @command varchar(1000)
SELECT @command = 'select * from table'
EXEC sp_MSforeachdb @command

```

However, all of these results are, as expected, returned in different result windows. What's the easiest way to perform a union of all of these results?