Friends.. .  I want to insert the row in the RTABLE( studentid, studentname , studentphoto).

STABLE have a  studentphoto values , and DTABLE have a studentname

I want to insert the RTABLE values from STABLE values and DTABLE values.

Is this possible ? how.. .

• Moved by Dave PatrickMVP 17 hours 39 minutes ago

Could you try below query?  (Assuming you have StudentID in each table)

INSERT INTO RTable
SELECT STable.StudentID, 
    STable.StudentPhoto, 
    DTable.StudentName
FROM STable
INNER JOIN DTable
ON STable.StudentID = DTable.StudentID