INSERT SELECT in older version of MySQL

[Jay Blanchard]

mysql> INSERT INTO Employee.tblNiiEmployee (empEmail)
    -> SELECT b.Email_Address
    -> FROM Employee.tblNiiEmployee a LEFT OUTER JOIN UserDB.Corporate b
    -> ON(a.empUsrName = b.Unix_Username)
    -> WHERE b.Email_Address IS NOT NULL;

Since versions prior to 4.0.14 do not support using the same table in
the FROM clause what would be the best way to solve this? TIA!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]