I'm having problem in inserting into table. I'm inserting data from one table into another
insert into table1 select * from table2 where condition = expression
I have 962 records in table2 for specified condition, but only 105 rows are getting inserted.
Both tables are in same database.
What could be problem? Please help me to get out of this problem.