>Sir, your query is displaying strange result
>
>id_a names date qty_a id_b qty_b
>1 ADMIN 2/19/2017 25 1 25
>2 GENERAL 2/17/2017 29 2 29
result is what you expect, you just need to specify the columns:
select table1.*;
from table1;
join (select id, max(qty) as qty from table1 group by id) table2 on table1.qty = table2.qty
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/Never explain, never complain (Queen Elizabeth II)