RE: Simple SELECT question

2003-03-05 Thread Mike Hillyer
Ok, lessee... SELECT user.user_id, user_name, user_history FROM user, history WHERE user_history LIKE %58% AND user.user_id = history.user_id; That should do what you need, lemme know. Mike Hillyer http://www.dynamergy.com/mike -Original Message- From: [EMAIL PROTECTED]

Re: Simple SELECT question

2003-03-05 Thread Bruce Feist
[EMAIL PROTECTED] wrote: I need a little help querying 2 tables in MySQL; Table User User_Id // Id = 2 User_Name // John Table History User_Id // 2 User_History // John has born in 58 SELECT User_History FROM History WHERE User_Id = 2; // return John has born in 58 But what my SELECT

Re: Simple SELECT question

2003-03-05 Thread Ryan McDougall
--- [EMAIL PROTECTED] wrote: I need a little help querying 2 tables in MySQL; Table User User_Id // Id = 2 User_Name // John Table History User_Id // 2 User_History // John has born in 58 SELECT User_History FROM History WHERE User_Id = 2; // return John has born in 58 But