Join twice on a different column (only 2 input datasets)

John-Peddle

I've looked but unable to find anything to indicate it's been asked or that it's ever been addressed but we're looking to join an input dataset 2x (same column) to the other input dataset but on a different column each time; is this possible?

 

Example:

Table 1: Conversation Assignee and Conversation Rating Assignee (Dataset 1)

Table 2: Agent Name (Dataset 2)

 

We want to left join Agent Name to Conversation Assignee, and then left join on Agent Name again, but this time with Conversation Rating Assignee.

 

This is how we've joined the first instance, which seems to work fine:

SELECT a.*,b.*
FROM
`Conversations` a
LEFT JOIN `Employee Roster` b ON a.`Conversation Assignee` = b.`Agent Name`*

  

The closest example we found online to what we want to accomplish is slightly different, and we haven't been able to figure out what needs to done to make this work (up until a month ago, I worked w/ETL but have been trying to better understand and use MySQL since it's going to benefit the company long term as well as myself!

 

Screenshot 1 (request for assistance): 

Screenshot 2 (response):

NewsomSolutions

Also if for some reason the mysql in domo doesn't like the last option, you could create a new column in that table employee roster table by doing something like this "select agent name, agent name two from employee roster...and then on your join you'd be technically joining two seperate columns...but the values would be the same.