sql - insert row into the table from values in two tables -
i want insert row in table. problem how values 2 different tables tables. itable has 3 columns ( studentphoto , studentname , studentid ) dtable has (studentphoto , studentid ) ltable have (studentname, studentid) i want insert data table itable table dtable , ltable . is possible , if yes, how? try insert itable (studentphoto , studentname , studentid) select d.studentphoto,l.studentname,d.studentid dtable d inner join l ltable on d.studentid= l.studentid