I would like to copy the values from each record in the Program table to another table (tblPrograms). This is the syntax I came up with:
select * from Program insert tblPrograms set ProgramCode=Location, ProgramName=Description; However, it fails without telling me why. Perhaps someone could correct me or re-direct me on this issue? Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
