Unioning two tables with different number of columns

by

Add extra columns as null for the table having less columns like

Select Col1, Col2, Col3, Col4, Col5 from Table1
Union
Select Col1, Col2, Col3, Null as Col4, Null as Col5 from Table2

More Related Contents:

  1. Join vs. sub-query
  2. Find records from one table which don’t exist in another
  3. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  4. How to use GROUP BY to concatenate strings in MySQL?
  5. Natural Sort in MySQL
  6. Best way to test if a row exists in a MySQL table
  7. MySQL Insert query doesn’t work with WHERE clause
  8. Comparing date ranges
  9. Fulltext Search with InnoDB
  10. Rewriting mysql select to reduce time and writing tmp to disk
  11. How do I convert from BLOB to TEXT in MySQL?
  12. Which SQL query is better, MATCH AGAINST or LIKE?
  13. Maintaining order in MySQL “IN” query
  14. MySQL: What is a reverse version of LIKE?
  15. Select TOP X (or bottom) percent for numeric values in MySQL
  16. MySQL select where column is not empty
  17. MySQL: GROUP_CONCAT with LEFT JOIN
  18. Hamming distance on binary strings in SQL
  19. Is it possible to have a default parameter for a mysql stored procedure?
  20. Renaming foreign-key columns in MySQL
  21. How to convert from varbinary to char/varchar in mysql
  22. MySQL GROUP BY behavior
  23. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  24. Update multiple rows with one query?
  25. How to change string date to MySQL date format at time of import of CSV using MySQL’s LOAD DATA LOCAL INFILE
  26. How important are lookup tables?
  27. how to use LIKE with column name
  28. How to implement a Keyword Search in MySQL?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment