boolean searches on multiple tables

[stroll]

We are having problems performing boolean searches using ZTBool on a normalized database structure. The problem we are having is when the user attempts to perform an 'AND' operation. Because our tables are fourth order normalized each entity only appears once in the table and is always by itself. This causes the 'AND' clause to return 0 hits every time because there are no instances of more than one entity anywhere in the tables.

Thanks

 

[iza]

try asking in the sql forum !