lundi 10 août 2015

how to fetch records from two tables using foreign key

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