get updated date field row after inner joining table
<p>I have a situation where a row is inserted whenever a schedule is created with call_back_date value
<code>la_id</code> is the same for each row, i want get a most recent row that is <code>max(call_back_date)</code>
I have written this query which fetch all the entries for those schedule after inner joining three tables:</p>

<pre><code>SELECT
la_details.application_no, 
la_details.id la_det,
la_details.client_id client_id,
la_details.la_name la_name,
la_details.sex sex,
la_details.advisor_name advisor_name,
la_details.client_phone client_phone,
la_details.client_mobile client_mibile,
la_details.level level,
la_details.state state,
la_details.pin_code pin_code,
trans_schedules.id schedule_id, 
trans_schedules.*, 
comments.descriptions
FROM
la_details
INNER JOIN trans_schedules 
ON 
trans_schedules.la_id=la_details.id
INNER JOIN comments  
ON 
comments.comment_id=trans_schedules.comment_id
WHERE
(trans_schedules.comment_id&lt;&gt;'1' 
OR
trans_schedules.list_followup = '1'
OR
trans_schedules.counter_flag='0') 
AND 
la_details.case_closed='0'
ORDER BY 
trans_schedules.call_back_date 
) a1 INNER JOIN 
(
SELECT la_id,MAX(call_back_date) AS call_back_date from
trans_schedules group by la_id                                                               
) b1 on a1.la_det = b1.la_id and a1.call_back_date  = b1.call_back_date
</code></pre>

<p>My question is how could i use a subquery on previous query to get max call_back_date row
Thanks in advance for help!!!!</p>