Anonymous

SELECT 	terminal_id FROM bg_person_answer WHERE   	( question_id = 1 AND answer_id = 1 ) AND	( question_id = 2 AND answer_id = 5 )mysql> desc bg_person_answer;+-------------+------------------+------+-----+---------------------+-------+| Field       | Type             | Null | Key | Default             | Extra |+-------------+------------------+------+-----+---------------------+-------+| terminal_id | int(11) unsigned | NO   | MUL | 0                   |       || question_id | int(11) unsigned | NO   | MUL | 0                   |       || answer_id   | int(11) unsigned | NO   | MUL | 0                   |       || freetext    | text             | YES  |     | NULL                |       || date_time   | datetime         | NO   |     | 0000-00-00 00:00:00 |       |+-------------+------------------+------+-----+---------------------+-------+