mysql get amount value of maximum date
<p>I have table A like this:</p>

<pre><code>mydate       kodetb   amount
-----------------------------
2016-03-10   203      600
2016-03-11   203      100
2016-03-11   200      110
</code></pre>

<p>and i have table B like this</p>

<pre><code>kodetb  service  
---------------
200     ok
203     not ok
</code></pre>

<p>i want to display result like this:</p>

<pre><code>kodetb   mydate     amount    service
--------------------------------------
200     2016-03-11  110       ok
203     2016-03-10  100       not ok
</code></pre>

<p>where second line result 100 displayed because it has LATEST/biggest date</p>

<p>pls help</p>