Thanks much.  I got the max and it did work.  It really did not matter which one from the second table were selected, I just needed only one of them. ...