create table studentsDetail (
student_id integer primary key,
rollno text,
name text,
stream text,
school text
);
create table studentsInfo (
studentinfo_id integer primary key,
stdetail_info_id integer,
fathername text,
mothername text,
age text,
address text,
FOREIGN KEY(stdetail_info_id) REFERENCES studentsDetail(student_id)
);
I want to fetch record from both table using foreign key. How can I do it easily?
Aucun commentaire:
Enregistrer un commentaire