>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!

Hey, no offence taken. Everybody has right of His/Her own opinion. We here just share this opinion :-)