Join getting hard
Hello everybody,
I use mySQL as a hobbie so all I know about it is from the official manual. Today I did my first JOIN and it works but now I need to do another one more complicated and I don't know how. I'm doing a web based game:
table players
-------------
head | chest | legs | feet | rhand | lhand
------------------------------------------
1 | 3 | 1 | 2 | 4 | 1
table items
-----------
id | name
-----------
1 | nothing
2 | boots
3 | shirt
4 | dagger
In the players table I only save the id of the items but when I want to show them to the user I want to names to appear. Finally I did one SELECT for each column from "players" as I don't know how to put all together in one SELECT (if it's possible).
Anyone could give me a hand? I'm sure it can be done but I'm stuck right now.
Thank you!
Subject
Written By
Posted
Join getting hard
November 11, 2009 08:23PM
November 11, 2009 09:45PM
November 12, 2009 06:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.