insert语句与column　fore

select * from balance where subid not in (select subid from subject) select * from initbala where subid not in (select subid from subject) delete from initbala where subid not in (select subid from subject)