I'm trying to create a SQL query in Marketing Cloud Automation Studio, where I use the same column EventName from multiple tables _Sent, _Open, etc but I get an error message "The column 'EventDate' was specified multiple times for 'Qry'.

Marketing Cloud Tables

In my query I use multiple Inner Joins, and I used aliases to select the multiple EventDate columns from the different tables (S.EventDate, O.EventDate, B.EventDate, etc)

It seems that it's not possible to select multiple times columns with the same name, even when using aliases.

  • 3
    Can you show the query as it is very unclear what you are asking exactly from your question. What exactly do you mean by 'select multiple times columns with same name'? Are you trying to have multiple columns in same select with those values? Combine into one column? etc... Jan 31 at 18:57

1 Answer 1


Based on the error message, it seems that you need to specify a different “output” name (alias) for each of those columns if you need all of them in the results, like this:

S.EventDate as SentEventDate,
O.EventDate as OpenEventDate, 
B.EventDate as BounceEventDate

Or, just include one of them in the query and disregard the rest as they are all the same anyway:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.