Hi List, I have the following query where I am trying to locate a single students record. I only know that the students record has an id of 3690 and an employer_id of 3 possibles. So I thought that OR would work great. The problem is that it returns all students with employer_id's of 3, 78, 79. How do I construct the query correctly to accomplish what I am after, without only using the student_id? I need to verify and return the employer_id.
SELECT student_id, employer_id FROM wat_student_job WHERE student_id = 3690 AND employer_id = 3 OR employer_id = 78 OR employer_id = 79 Thanks in advance. Regards, Justin Palmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]