Thank you very much Lachlan and SpamVortex! I appreciate the help!
Jonathan
[EMAIL PROTECTED] 07/07 6:59 pm
You can do it one of two ways.. Either you can do a
self join like the following:
select t1.userid
from answers t1,
answers t2
where t1.qid = 5
and
I am trying to figure out what my select statement should be to combine
both of these into one:
SELECT userid FROM Answers WHERE answer like Education%;
SELECT userid FROM Answers WHERE answer=Student;
Table Answers looks like:
-id int
-userid int
-answer text
for each row there would be
: Jonathan Duncan [mailto:[EMAIL PROTECTED]
Sent: Thursday, 8 July 2004 10:04 AM
To: [EMAIL PROTECTED]
Subject: selecting rows that match two criteria
I am trying to figure out what my select statement should be to combine
both of these into one:
SELECT userid FROM Answers WHERE answer like Education
You can do it one of two ways.. Either you can do a
self join like the following:
select t1.userid
from answers t1,
answers t2
where t1.qid = 5
and lower(t1.answer)='student'
and t2.qid = 6
and lower(t2.answer) like 'edu%'
and t1.userid = t2.userid
or you can use a union