adding dummy column to select statement

Operating System Apple Mavericks
LibreOffice Version 4.2.6.3
Application Base

I’m creating a union query to combine two tables but one of the tables has an extra column, that needs to be in the query. How do I use the select statement to add the extra column to the second table with a fixed string in each row.

in access “Text String” AS [Column Name] works but this seems to be illegal syntax in base