Combine the Table and Insert a value

[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;

 

[RonaldoOneNil]

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;