SELECT 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.
