Home Forums SQL Server 2008 T-SQL (SS2K8) create table by using select command return data? RE: create table by using select command return data?

  • October 24, 2012 at 3:48 am

    #1552190

    you'll need to specify each column in the select statement and for the dupe column names use AS to rename.

    eg

    SELECT

    a.dupe_col as dupe_col_1

    ,b.dupe_col as dupe_col_2

    from tableA a

    join tableB b on ..............