>Sergey,
>
>Take a look at this....
>
>
>http://www.rns-sheppick.com/ronnie1.jpg

In the WHERE clause at the end:

- if t1.vnd_id is numeric, then it should be

WHERE t1.vnd_id > 1
* note that the 1 is not quoted above - quoting turns it into a character string

- if t1.vnd_id is actually character, your code doesn't give a syntax error but it might not be doing what you would expect. In that case you need to left-pad both the field contents and your comparison string with either zeroes or spaces. Suppose t1.vnd_id is C( 4 ):

* in the Command window:
? "2" > "1"        && .T.
? "2" > "12"       && .T.
? "0002" > "0012"  && .F.
? "   2" > "  12"  && .F.