Combine the Table and Insert a value

  • Thread starter Thread starter Ranjith Kurian
  • Start date Start date
R

Ranjith Kurian

I tried the below query using 23 tables, i got a error "Duplicate output
alias File_Date, could you please advise me.

SELECT Mon.[Customer Name (DFF)], Mon.Amount, "weekMon" AS File_Date
FROM Mon
Union All
SELECT Tue.[Customer Name (DFF)], Tue.Amount, "weekTue" AS File_Date
FROM Tue;
 
Your field names are derived from your first statement in a union query so
you do not need to specify it in the statements after.

SELECT Mon.[Customer Name (DFF)], Mon.Amount, "weekMon" AS File_Date
FROM Mon;
Union All SELECT Tue.[Customer Name (DFF)], Tue.Amount, "weekTue" FROM Tue;
 
Back
Top