merging two tables with same column in meaning into one

Question

I've got tables like this:

Table Articles
---------------
AID(PK)   Name   PublisherID   Words


Table Books
---------------
BID(PK)   Title  PublisherID   Date

I want to merge them like:

Table Total
---------------
Title   PublisherID

In this new table, Name in Table.Articles will belong to Title column, because.. Articles.Name and Books.Title mean the same thing :)

Any answers will be very appreciated :)

Thanks

Answer 1

select title, publisherid from books
union all
select name, publisherid from articles

Answer 2

As I understand, you are looking for the result of this:

select name, publisherId
from TableArticles
union 
select title, publisherId
from TableBooks