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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
