Nice

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?

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