Have a query that displays all results twice
===

I need a query that results all rows twice.
Using a union isn't possible (as it has to become an indexed view.

Anybody know how to do it?

(So this I can't do:)
select * from tags
union all
select * from tags