I am trying to figure out what my select statement should be to combine both of these into one:
SELECT userid FROM Answers WHERE answer like "Education%"; SELECT userid FROM Answers WHERE answer="Student"; Table Answers looks like: -id int -userid int -answer text for each row there would be something like: +-----+--------+----------+ | qid | userid | answer | +-----+--------+----------+ | 5 | 3000 | Student | +-----+--------+----------+ There are often multiple asnwers for each question. I want to select the userid's from the table where people answered "Student" in question 5 and "Education" in question 6. I am using MySQL 4.08 so I can't do the subquery thing. Thanks, Jonathan Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
