2005/9/23, Gordon Bruce <[EMAIL PROTECTED]>: > What am I missing > > INSERT INTO table1 (column names.....) > SELECT VALUES...... > FROM table2 > WHERE primary id = insert value > > You will have to put in your real table name and column names. >
nice and easy :-) -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]