Hello Andreas, You could try with this:
> insert into table1 (authorid, lastname, firstname) > values (nextval('s_authors'), 'Meyers', 'Scott'); INSERT INTO table1(authorid, lastname, firstname) VALUES (null, 'Meyers', 'Scott'); > insert into table2 (authorid, title, subtitle) > values (currval('s_authors'), 'Effektiv C++ Programmieren', > '50 Wege zur Verbesserung Ihrer Programme und Entwuerfe'); INSERT INTO table2 (authorid, title, subtitle) VALUES (last_insert_id(), 'Effektiv C++ Programmieren', '50 Wege zur Verbesserung Ihrer Programme und Entwuerfe'); Best regards, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]