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.