You still haven't provided a proper explanation or a decent example. For a start, you say that you want to get the "max base on dates". That doesn't really make sense. Please provide a PROPER description. Also, your example has the same date in every record, so how does that help us see what you want.

Are you maybe saying, without actually saying, that you want one record for each ID that appears in both where the value for the date is the maximum from the two tables? If so, please say so. It's very frustrating when you're trying to help but you have to guess what's actually required. You know and we don;t, so you need to tell us. Assume that two many words are better than not enough.