Joining two tables but getting no result

Table1

Move1       Move2  
Fire        Ice          
Grass       Fire   
Ice         Grass        

Table2

Move        Power
Fire        40   
Grass       30  
Ice         20  

I have these two tables, but when I run this SQL statement in WAMPServer, I get no rows returned:

SELECT *
FROM Table1, Table2
    INNER JOIN Table1 as Hello ON Hello.move1 = Table2.move
    INNER JOIN Table1 as Meow ON Meow.move2 = Table2.move

Both tables are under the same database, so I can’t see my error. I want it to return something like…

Table1

Move1       Move2     Move     Power     Move     Power
Fire        Ice       Fire     40        Ice      20  
Grass       Fire      Grass    30        Fire     40
Ice         Grass     Ice      20        Grass    30

Where did I go wrong?


Source: wampserver

Leave a Reply