|
Have 2 tables TableA Have one more table B The conditions are max(date) of a particular student teacher meeting from table A matches the max(date) of the same student teacher meeting in table B with the value. I would like to see the resultset as something like How can i achieve the above resultset
(comments are locked)
|
|
It sounds a lot like the versioned data I've worked with before. I wrote up an article using various methods to retrieve the data. Check this out. I'm sure one of them will meet the requirements you're looking for.
(comments are locked)
|


Forgive me, but the MAX(Date) in TableA won't ever match the MAX(Date) with TableB with the given data. Is there another row in TableB that we are not seeing? Or is that selection criteria need to be different? If I am misunderstanding, please feel free to let me know.
For the student teacher combination from table A ...i need the max(date) and value of the same studentnt teacher combination from table B