สอบถามบันทึกข้อมูล จาก 2 ตาราง (table_A, table_B) ลงอีก 1 ตารางใหม่ table_O

//select
select   c.id_num , c.id_name , c.date  
	from (select  id_num ,id_name, date    from `table_A` 
	UNION  
	select  id_num ,id_name ,date   from  `table_B`)  as  c 
	 order by  c.id_num  DESC




//insert
$sq_insert="insert ignore into  `table_O` (id,id_num_O , id_name_O , date_O , number) values ('','$id_num' , '$id_name' , '$date' , '$number')";
$qu_insert=mysql_query($sq_insert);