. In absence of this kind of technique I was struggling with the idea of multiple "SELECT FROM's" within a single "INSERT" (is that even possible?)
I'm not sure what you mean here.
Will something like this work (with a correction of syntax which is unknown to me)?
INSERT INTO webpages(author_key, subject_key, title, description)
SELECT MAX(author_key) from authors,
SELECT MAX(subject_key), title, description, from subjects;
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
