>>>>> "Alain" == Alain Fontaine <alain@stripped> writes:
Alain> Hello,
Alain> I am running the latest Win32 shareware version (not yet registered) on
Alain> Windows98.
Alain> I have a database containing about 7 tables. The main table is called
Alain> "products", containing computer equipment.
Alain> This table contains 9 records.
Alain> When I do the following SELECT statement:
Alain> ----
Alain> select products.prod_id,products.name,products.costprice,
Alain> products.manufacturer,products.promotion,products.webpage,products.profit_pe
Alain> rcent,
Alain> products.currency,products.top_pick,manufacturer.num,manufacturer.name,
Alain> manufacturer.webpage, currencies.ISO, currencies.rate,
Alain> products.category_2,sub_categories.num,
Alain> sub_categories.name
Alain> from products, manufacturer, currencies, sub_categories
Alain> where products.manufacturer=manufacturer.num
Alain> and products.currency=currencies.ISO
Alain> and products.category_2 = sub_categories.num
Alain> and products.name LIKE '%pent%'
Alain> OR manufacturer.name LIKE '%int%'
Alain> ----
Alain> the query return 2295 rows (obviously, with 9 records in my products table,
Alain> this seems strange).
Hi!
You don't have any braces around:
'OR manufacturer.name LIKE '%int%''
This means that you say:
'for any combination of the rows of all preceding tables', give me all
rows that has 'int' somewhere in name.
I assume you want to do something like
...
WHERE products.manufacturer=manufacturer.num
and products.currency=currencies.ISO
and products.category_2 = sub_categories.num
and (products.name LIKE '%pent%'
OR manufacturer.name LIKE '%int%')
Regards,
Monty
