What is the link between the two table? Roll?
select pupil.*,name from pupil,student where pupil.roll = student.roll into cursor myresult
>I have two tables: (1) Student (2) pupil
>In student the field strutures are name-c-30, roll-n-5,age-n-4
>and in pupil roll-n-5, math - n - 3, english-n-3, computer-n-3,
> ggraphy - n -3
>
>I want to select name from student and other fields from pupil useing
> SQL command by entereing Name in form text.
>
>How I can have desired result for Name? Please help.