Got a bit of a dilemma here. I have data that is stored thus
AID QID MID answer
585 11 1016
586 14 1016
619 1 1033 Hmmm
620 15 1033 Creative Partnerships Staff
621 15 1033 Cultural Organisation
MID = memberID
AID=AnswerID
QID = QuestionID
I need to pull out all distinct memberID's where they have for example
QID = 11 and answer = "whatever"
AND
QID = 12 and answer = "something"
AND
Addiitonal requirements here
Of course a standard AND wont work as it is different rows not different
columns.
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
