subject:"INSERT SELECT in older version of MySQL"

RE: INSERT SELECT in older version of MySQL SOLVED

2004-10-15 Thread Jay Blanchard

[snip] 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 usin

INSERT SELECT in older version of MySQL

2004-10-15 Thread 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 s