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