Would Verity be better for this? Or indexing? -----Original Message----- From: chad [mailto:[EMAIL PROTECTED]] Sent: 23 May 2002 16:02 To: CF-Talk Subject: SQL search with related tables
Im writing a SQL statement to take a search word and go through the database to find records that match. Well i want to search all the related tables of the products. The database is kind of the standard product database. Category Table that relates to a SubCategory Table, that relates to the Product Table. So im trying to Join all the tables then use a LIKE to find the search word in the database. Is there a better way to search the database for matches? Thanks ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
