Posted by carrajo on 02/03/06 20:19

basically the tables and data that I'm working with:

user
-------
uid
fullname

INSERT INTO user SET uid = '1', fullname = 'John Smith'


user_answers ( users can have unlimited amount of answers )
-----
uid
answer

1 Brown Hair
1 Single
1 Tall
1 55

INSERT INTO user_answers SET uid = '1', answer = 'Single'
INSERT INTO user_answers SET uid = '1', answer = 'Tall'
INSERT INTO user_answers SET uid = '1', answer = '55'
INSERT INTO user_answers SET uid = '1', answer = 'Brown Hair'


I want to return all users that have Brown Hair, Single and Tall

This doesn't work for me:

SELECT users.* FROM users, user_answers
WHERE users.uid = user_answers.uid
AND user_answers.answer = 'Brown Hair'
AND user_answers.answer = 'Single'
AND user_answers.answer = 'Tall'

Could some help please.

Thanks

[Back to original message]