Simple SQL, what am I doing wrong!!??

[Al Neri]

I have a table

Table Name:Name
NameID...Name
1.............John
2.............Mike
3.............Bill

Table Name:Color
ColorID...Color
1.............Red
2.............Blue
3.............Green

Table Name:Match
NameID...ColorID
1..............2
2..............3
3..............1

I want it to ouput:

John Blue
Mike Green
Bill Red

I tried... which didnt work

Select Name, Color from Name, Color, Match where Name.NameID=Match.NameID AND Color.ColorID=Match.ColorID which outputs what looks like all possible combinations....

What am I doing wrong?

What is this process called?

 

[Cerebus451]

Just created these tables real quick in MySQL and used your query and got the expected results. Not sure what you are doing wrong. Which database engine are you using?

 

[Al Neri]

mysql

 

[Al Neri]

it did work i messed something up,
of course i typed it perfect in the post 🙂

 

[Al Neri]

doublepost

 

[troytime]

edit, nevermind, i'm a tard