I know this is possible but I'm not real sure of the command to use. I have 2 tables that are pretty much identical except for one column. What I want to do is moved data from one table column to the other table column based on a matching id number that is also a column in both tables called "id".
UPDATE table2 SET active = '1' WHERE table2.id = table1.id; is this the correct syntax? Thanks, Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]