u201d in field 204 then selects a price from field 206 e g u201c 500 u201d the user then activates the u201c search now u201d button 208 which causes software 102 to generate an appropriate sql query for u201c stoves u201d from u201c sears u201d which cost u201c 500 u201d and apply it against database 104 the results of the query are then provided to the user or the system the results may be provided on display 106 to a printer not shown to a disk in a written format to another database to another computer or to any output device known in the art referring to fig3 an sql query generated by software 102 from the criteria entered by the user is shown in query syntax 300 query syntax 300 comprises u201c select u201d clause 302 u201c from u201d clause 304 and u201c where u201d clause 306 u201c select u201d clause 302 identifies the table columns of database 104 from which the response to the query is generated u201c from u201d clause 304 identifies the tables from which the query will generate its response u201c where u201d clause 306 identifies specific items 312 from the tables for which the user provided specific search criteria relating the contents of clauses 302 304 and 306 to query screen 200 parameters in field 308 identify the description field 202 and manufacturer field 204 parameter 310 identifies the tables in which description field and manufacturer field information are stored in database 104 parameters in field 312 identify queries relating to description field 202 manufacturers field 204 and price field 206.