> A typical query then may look like this: > > Select all 'toys' from 'Walmart' where average_sales(100) > 100000 and > avaerage_cost(100,10) <= 1 and item_date between "01-Jan-00" and > "01-Jan-06"
See Microsoft's English Query for SQL Server or the SQ-HAL project for examples: http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part9/c3261.mspx?mfr=true http://www.csse.monash.edu.au/hons/projects/2000/Supun.Ruwanpura/ In general, it's easier to write the SQL than to optimize natural language-based query translation. -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 2nd Floor | [EMAIL PROTECTED] Iselin, New Jersey 08830 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings