I am try to copy a couple of fields from one table to another. Here is my query
Insert into users_test (firstName, lastName) Select firstName, lastName from users; The users table has 1,263 rows. However, only 1 row is inserted into users_test. If I perform the following query Insert into users_test Select * users; all the rows are inserted. What am I doing wrong in the first query? thanks, Luis R. Lebron Sigmatech, Inc