apw Posted April 20, 2009 Share Posted April 20, 2009 Hello i am woundering about how to correctly join one or more tables together. The tables in question would be my km_user and presource tables. The field theses tables have in common would be the ID that is given to then when player registers. Ive read through the tutorial about this topic on this website but am still lost so any help would be appreciated. Quote Link to comment Share on other sites More sharing options...
GingerRobot Posted April 20, 2009 Share Posted April 20, 2009 Well that kind of depends on what you're trying to achieve. If, as you said, you've read the tutorial on the main site, then you'll know there are various types of joins, each of which are used for different reasons. We need more information in order to answer your question. What fields are in the respective tables? What information are you looking to generate? Quote Link to comment Share on other sites More sharing options...
apw Posted April 20, 2009 Author Share Posted April 20, 2009 The fields in the km_user table are which handles the login info for players! id, empirename(username) and password the presource table, which handles what resources the player has are: id, empirename(wasnt sure if this was necessary), food and wood. What im trying to do is keep everything seperated and not confusing and jumbled into one large table. Quote Link to comment Share on other sites More sharing options...
revraz Posted April 20, 2009 Share Posted April 20, 2009 Learn JOINs here http://www.sqlzoo.net/ Quote Link to comment Share on other sites More sharing options...
fenway Posted April 21, 2009 Share Posted April 21, 2009 Or by reading the stickies. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.