>>>Thanks, I will try that. Madam, Please te;; where Should i start learning such SQL from Starting to complex one.?

If you want to learn VFP's SQL, you might try my book:

http://www.hentzenwerke.com/catalog/tamingvfpsql.htm

It takes you through all the SQL language in VFP. In addition, I have a number of papers about VFP's SQL at http://www.tomorrowssolutionsllc.com/publications/conferencepapers

Tamar