Cannot Perform mySQL Inner Join

Nick_Commisso_X · June 2018

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

user05920 · July 2018

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.

Archive

Archive

Cannot Perform mySQL Inner Join

Comments

Welcome!

Welcome!

Quick Links

Categories