Trying to join tables and select by one distinct max value?

Your GROUP BY should contain all the non-aggregated columns that is: GROUP BY 'p'.'id', 'o'.'id', 'o'.'email', 'd'.'number.

You cannot simultaneously select both the number and the MAX number while grouping. This is because the MAX function is based on the aggregate of your grouping. In your case you are also selecting the column itself, which will create a row for each distinct number... not each distinct MAX number.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.