SQL query to find all users with an entry in each of separate date ranges
Posted on 2013-12-04
table 1 has user info, user id, full name, email, etc
table 2 has test info, user id, date of test, q1, q2, etc
user id is the link between tables
I need a query that will give me a list of all the users that took at least 1 test between 10/01/2012-12/31/2012 AND took at least 1 test between 10/01/2013-12/31/2013
mySQL is my database of choice, but this application also runs on some other SQL databases so less DB specific and more generic query would be helpful.
I would really appreciate help with this.