Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
inner join/subqueries
I have a survey with 3 questions. I only want to select the 3 questions and answers from the people (id) who give 1 as answer (a) on question (q) 3. |id|q|a| |27|1|3| |27|2|2| |27|3|1| |29|1|3| |29|2|1| |29|3|2| |22|1|2| |22|2|3| |22|3|1| With this query: SELECT E2.id AS E2id, E2.q AS E2q...
