If I run this query on VFP Table then the result is OK and If on MySql Table then there is no result

MySql Query is as under:
= SQLEXEC(mConn,"Select T1.* From Inv T1 Inner Join (Select Itm_Code, MAX(Date) as LastDate From Inv Group by Itm_Code) T2 ;
on T1.Itm_Code = T2.Itm_Code and T1.Date = T2.LastDate")

Rgds:
Ahsan Rana