Not sure I understand. What's the dilemma? And if no dilemma, what's the problem?
> -----Original Message----- > From: Snake [mailto:[EMAIL PROTECTED]] > Sent: 25 November 2002 17:04 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Dynamic SQL column data > > > 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] > > -- ** 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]
