MySql can't have a semicolon (;) in the script. Try this.
lnResult=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")
>>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
>
>I'm not sure why it will not give your result in MySQL. May be the JOIN based on date is failing for some reason? What if you only do inner select in MySQL?
>Also, remove ; after T2 in MySQL