Hi Fabio,

>if you want resolve the problem for match and not match condition,
>then resolve for N items not for 7 items.

Of course you can, then you've got to use a second NOT IN (SELECT ... FROM ... GROUP BY ... HAVING COUNT(*) > nNumber) etc.

Look I did not say that your solution is not right. I said, it indeed was a good one (and I really meant that). However there are some differences in the approaches which I wanted to list.

>Your solution is not usable with more of 7 items.

Actually it is 9 (maximum of 9 EXIST clauses in VFP8).

>- for States ( more 200 items ) condition, what do you do.
>- for 100000 items ?

I think in these extreme cases you have to look really well about performance penalties becauses you're talking about a lot of potential records and hardly can avoid full table scans. Note that your solution is also limited (to 24 items) unless you choose to join it with a custom cursor.

>If you want to have reason, then you have reason.

There is no need to be picky, I'm just trying to be constructive.

Walter,