using union, temp columns, in a SQL based search string

Trying to wrap my head around how a good SQL search string would work. I have three tables (two in the example below for learning) with different column names (but similar data.) I'm using aliases to make uniform columns. I can get all the matching rows from the different tables, but I need to know what table the row came from for the results to be actually useful (linking, etc)

How can I ADD a completely fabricated column to my result set so I can know downstream which rows are stories, and which ones are gallery, etc. Here's a simplified version of my SQL:

SELECT storiesTbl.heroName as name, storiesTbl.writername as author FROM storiesTbl WHERE storiesTbl.heroname like '%marley%'
UNION
SELECT gallerytbl.title as name, gallerytbl.artist as author FROM gallerytbl WHERE gallerytbl.title like '%marley%'



Or is this backwards logic and is there a better way to do this?

Thanks in advance to anyone who can help!

re: using union, temp columns, in a SQL based search string

I am assuming your query is working ok and you just want to add a field identifying the table

re: using union, temp columns, in a SQL based search string

Ah ha! That makes a whole lot of sense. Thank you much...

Also, I haven't researched this yet (so I guess I'm just being lazy by asking) but if I had two columns in a row and I wanted to concatenate the strings and return them in a single column, how could I accomplish this?

re: using union, temp columns, in a SQL based search string

I encourage you to research first, you will learn most from researching things for yourself and asking for help where you have difficulty ;)