1.2.3.6.Combine the Tables - UNION

  • select union table

select * from people union select * from  people2;
  • union兩個欄位不同的table

select id, name, city from people union select * from  people2;

Last updated

Was this helpful?