Posted by Steve Kass on 08/24/05 19:00

coosa wrote:
> Thanks for replying, Well with OR it will work, but i think because the
> relationship between item_table and details_table is 1-M so all those
> many details are within one or more items. Is there a way to find
> results within all of them?
> Actually the item_id 2 which is "AMD 3200+" does indeed have under it
> all of the details "amd socket a 32 bit cache 512 dell" except "dell"
> and item_id 3 which is "Dell P780" has under it the word "dell"; how is
> it possible to include all without "OR"?

If you request items matching 'dell', you will get back
items matching 'dell' only, and you won't get back item #2.

Can you please show the exact result you want, since it sounds like
you don't want the result of using AND, but you don't want the result
of using OR. But your description "find results within all of them"
is not at all precise. It would help if you gave several examples
where neither OR nor AND gives you the results you want.


Steve Kass
Drew University

> My reasoning is that the user searching will assume that he will get a
> result that includes "All" as a must and not optional.
>
> Best regards
>

[Back to original message]