Click to See Complete Forum and Search --> : Insert based on SELECT


lebronletchev
12-10-2008, 04:05 AM
Hello,

I never did an INSERT from a SELECT. Could your please give me a bit of your background to correct it?


SQL="INSERT INTO to jointone(title) SELECT masters.title FROM masters INNER JOIN keywords ON masters.fileid=keywords.id "

conn.execute (SQL)

Best regards

Lebron:confused: