>
>client_id cat_code item_code
>10 1 3
>10 2 1
>10 6 8
>11 1 4
>11 1 3
>
>then try to find every client_id whose cat_code=1 and item_code=3
>and cat_code=6 and item_code=8 .
>got it now ?
>Thanks again for your help, I really apreciate it.

SELECT .... WHERE cat_code=6 and item_code=8 ;
unioun;
SELECT .... WHERE cat_code=1 and item_code=3 ;
INTO CURSOR Query1 ...

HTH

Arnon