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]
