RE: SQL search with related tables

2002-05-23 Thread chad
Why do i always forget about Verity? Sorry for the dumb post. At 04:03 PM 5/23/2002 +0100, you wrote: >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: SQ

RE: SQL search with related tables

2002-05-23 Thread Adrian Lynch
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

SQL search with related tables

2002-05-23 Thread chad
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 th