>It seems like we ought to be able to create a view into a specific database
>without selecting the database after all we select into a database without
>having it selected.
>
>However, I think it can't be done. Anyone able to refute this?
Nope, I can't. Looks like you've exhausted all the creative possibilities here, so I'd say you have to do it in two lines, as you stated.