Cannot Perform mySQL Inner Join

Nick_Commisso_X

Hi 

 

I'm trying to make a simple Inner Join but the ETL does not produce data for some reason and my mySQL does not have the correct syntax. I've tried a combination of backticks and table.column format anfd nothing seems to work correctly. Can someone take a look please? 

 

SELECT *
FROM `elevate_seats_june_28_2018`
INNER JOIN `sales_persons_master`
ON elevate_seats_june_28_2018.Email Address = sales_persons_master.EMAIL

DOMO MYSQL.PNG

user05920

Maybe you need backticks on the last line, like this:

SELECT *
FROM `elevate_seats_june_28_2018`
INNER JOIN `sales_persons_master`
ON `elevate_seats_june_28_2018`.`Email Address` = `sales_persons_master`.`EMAIL`

Personally, when in doubt, I backtick every table name and field name.