I haven't used mySql but there has to be a tool that you can test the query without using VFP. You need to start at the least common denominator for testing and then work back into VFP.

>SQLEXEC have the positive value and giving me result from other queries
>
>Rgds:
>Ahsan Rana