[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 using the same table in
the FROM clause what would be the best way to solve this? TIA!
[/snip]
I wrote script...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
