MySQL DataFlow

Ajita

I am having hard time in joining two tables using MySQL DataFlow (transform).

SELECT a.Name, a.Id, a.state,b.Year,b.Gender
from state a join
national_names b
on a.Name = b.Name anda.Year = b.Year

MichelleH

@Ajita It looks like you aren't specifying what kind of join you want to do. You will need to add either LEFT, RIGHT, INNER, or FULL OUTER in front of the word JOIN.

GrantSmith

@Ajita

it would help to have more information. What is the error you’re experiencing? What are you seeing versus what are you expecting?

I’m not sure if it’s a copy and paste error but you might be missing a space

 and a.Year

MichelleH

@Ajita It looks like you aren't specifying what kind of join you want to do. You will need to add either LEFT, RIGHT, INNER, or FULL OUTER in front of the word JOIN.

GrantSmith

@Ajita

it would help to have more information. What is the error you’re experiencing? What are you seeing versus what are you expecting?

I’m not sure if it’s a copy and paste error but you might be missing a space

 and a.Year