Subject Re: [firebird-support] Re: Tough sql question
Author Bob Murdoch
At 10/29/2003 08:18 AM, you wrote:

>Hi Bob, I thought you'd relaxed for quite a few hours already, at
>least it is a while since I saw this question in ib-general.

Hah. Yes, I did take my nightly nap in between, and found Helen's
objection to my use of the wrong list this morning <g>.


>Reading your question as you wanting to return all orders which only
>contain items in your list, the query could simply be:

That's a great query. I looked at the problem for a half hour, trying to
do much more complicated things. Simple is good.


>By the way, I assumed you meant 'neither' rather than 'either' in this
>sentence: "If the target list was [Banana], either of the orders would
>match".

Yes, dead on.


Thanks again for the great solution.

Bob M..