Hi, Borislav!

>No problems at all when you want to select as many fields as you want, you >just must put alias before them:

Absolutely agreed with You, but I mean that you must change your code
in your answer, because I never change the original code of message that
was sended by another person.

>*** or for one field:
>SELECT Master.Field1;
> FROM TableName Master;
>JOIN TableName Child ON childs.pid=parents.id;
>WHERE Master.Field3 = something;
>INTO CURSOR crsTest

and now I violate my rules and write right code for Edgar,
because if You leave "SELECT Master.Field1" you will get the number
of records with the same values:

SELECT Child.required_field_name;
FROM edgar_table_name as Master;
JOIN edgar_table_name as Child ON child.pid=master.id;
WHERE Master.id = some_value;
INTO CURSOR crsTest

:)
With best regards,
Juri.

P.S. Borislav! I hope I'm not offended You?
Really, You are a great helper!