sql - Build a view to query multiple tables with identical column names -

i'm trying build view can write single query against it:

 datebase.dbo.[allqtrs] 

using sql server's 'create view' function, spits out following:

select            dbo.[2010 q3].*, dbo.[2010 q4].*,     dbo.[2011 q1].*, dbo.[2011 q2].*,     dbo.[2011 q3].*, dbo.[2011 q4].*,     dbo.[2012 q1].*, dbo.[2012 q2].*,     dbo.[2012 q3].*, dbo.[2013 q2].*,     dbo.[2013 q1].*, dbo.[2012 q4].*,     dbo.[2014 q1].*, dbo.[2013 q4].*,     dbo.[2013 q3].*, dbo.[2014 q2].*                dbo.[2010 q3]  cross join    dbo.[2010 q4]  cross join    dbo.[2011 q1]  cross join    dbo.[2011 q2]  cross join    dbo.[2011 q3]  cross join    dbo.[2011 q4]  cross join    dbo.[2012 q1]  cross join    dbo.[2012 q2]  cross join    dbo.[2012 q3]  cross join    dbo.[2012 q4]  cross join    dbo.[2013 q1]  cross join    dbo.[2013 q2]  cross join    dbo.[2013 q3]  cross join    dbo.[2013 q4]  cross join    dbo.[2014 q1]  cross join    dbo.[2014 q2] 

all of tables have identical column names/properties. error message receive

column names in each view or function must unique. column name xy specified more once.

the goal query tables querying against allqtrs view. help?

you must specify names manually , define unique names them. way you'll show columns. example be

select dbo.[2010 q3].column1 2010q3column1,         dbo.[2010 q3].column2 2010q3column2,         dbo.[2010 q3].column1 2010q4column1         etc. 

btw, make sure cross join want - looks want use union all here. cross join return cartesian product of rows tables, i.e. if there 10 rows in each table, 10^16 records, won't complete in few decades.

with union like:

select column1, column2 {add here remaining column names} dbo.[2010 q3] union select column1, column2 {add here remaining column names} dbo.[2010 q4] union select column1, column2 {add here remaining column names} dbo.[2011 q1] union ...etc