mysql design question ?

[Jonas Geiregat]

| user_id | Marks | Now I have an other table where I keep the name 
etc.. from each user. You will all kill me for this, but in access you 
could the setup a relation between user_id and the id of the user in the 
user table. Is something like that possible in mysql ?
So that if I select some data from the | user_id | Marks | table I get 
his name instead of his ID ?
or should I first get his ID, and with that ID query his marks out of 
the table ?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]