Popular Posts

  • Adding to Lists
    SQLServerCentral » Latest topics Adding to Lists Comments posted to this topic are about the item [B] Adding to Lists [/B] more in...
  • SSMS is Free
    SQLServerCentral » Latest topics SSMS is Free Comments posted to this topic are about the item [B] SSMS is Free [/B] more info... ...
  • The March of AI
    SQLServerCentral » Latest topics The March of AI Comments posted to this topic are about the item [B] The March of AI [/B] more in...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Sunday, August 27, 2017

Left outer join make duplicate column name

SQLServerCentral » Latest topics
Left outer join make duplicate column name
I used code below to select 10 temp tables as one row table.
All 10 tables has the same column [FileID].
How to make final table only list one [FileID] column?
SELECT DISTINCT
   *
  FROM #1 A01
   LEFT O
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)