Hi, > Then: INSERT INTO Extra_Credit (Student_ID, Points) SELECT MAX(Student_ID) > from Students,
> (1) ...VALUE ('25'); > or > (2) ... '25' as Points; I think this is your query: INSERT INTO Extra_Credit(Student_ID, Points) SELECT MAX(Student_ID), '25' from Students Take care, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]