I have a union query pulling information from two underlying tables. The underlying tables are using lookups to display a name instead of the primary key, so the data pulled in to the union query is the unique ID (numerical value). Is it possible to edit the SQL code in the union query to display the text like the lookups do in the underlying tables? I am self-taught in SQL and access in general so any guidance is appreciated.