Cannot Perform mySQL Inner Join

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

Comments

  • 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.