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
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
No comments:
Post a Comment