In my database i have a different table for each appointment that a client ttends. There are 5 appointments and the same measurements are taken at each appointment.
Activity Levels is one of the measurements taken at each appointment. I want to be able to have a query that finds the people whose activity levels have increased between the first and last appointment. Is this possible.
been thinking about this all day.....actually a better way of doing this sort of query would be to use the function max()
your query would now look like:
WHERE some_ability_score > (SELECT max(some_ability_score)
FROM sometable ); [and if you need to join tables
WHERE sometable.some_ability_score =
this takes the existing max value and checks to see if the value you enter is greter than it!