用途 用途从多个表是取出相似的字段,并合成到一个表中 --把不同表中的姓名和电话字段合成一个表SELECT name1 as name, tel_333 as tel FROM `table1`UNIONSELECT the_name as name, tel_3 as telFROM `table2`