Insert all those records of table Account into table Pending where amt_outstanding is more than 10000. / Sumita Arora Solution / By Sanjay Kumar INSERT INTO PendingSELECT * FROM AccountWHERE amt_outstanding > 10000;