Thanks for your guidance. But My problem is quite different:

In a form I shall enter a name. If the entered name is exists in the student table,
records from two tables will be obtained corresting to the entered name.
I have used this code but it was not giving the desired result.

use student
locate for name=lcName
if found()
select pupil.*,name from pupil,student where pupil.roll = student.roll and pupil.name=lcName into cursor myresult
else
wait window
endif

In this case How I shall proceed ?