>
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only