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 lower(t1.ans
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 (avail
riginal Message-
From: 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
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 som
