SSN, open_datetime, close_datetime, priority
ID, time, c_time, c_response, c_id
I need all the ssn, with an open date between 4/1/2010 and 4/30/2010, with a priority of 1 and need the c_response and time from table two. Only problem is that second table has multiple records for the same c_id. I need the first record of the second table based on c_id = SSN and c_time.