Combining data with different columns
suggest changeSELECT name, caption as title, year, pages FROM books
UNION
SELECT name, title, year, 0 as pages FROM movies
When combining 2 record sets with different columns then emulate the missing ones with default values.
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents