Combining data with different columns

suggest change
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.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:



Table Of Contents