MySQL DataFlow

Ajita
Ajita Member
in APIs & Domo Developer

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

Best Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @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
    GrantSmith Coach
    Answer ✓

    @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
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @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
    GrantSmith Coach
    Answer ✓

    @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
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories