sql - Retrieve full path of attachment from multiple linked tables in Microsoft Access 2013 -

i have used union query select values other queries

   select * 1dbform     union     select * 2dbform     union select * 3dbform; 

queries can retrieve attachment without error

select users.name, client_details.folio_number, client_details.date_of_registration, client_details.erv, client_details.jina, client_details.slp, aina_ya_viwanda.aina_ya_viwanda, aina_ya_viwanda.ada, client_details.cfullpath aina_ya_viwanda inner join (users inner join client_details on users.id = client_details.uid) on aina_ya_viwanda.id = client_details.[aina ya viwanda] order client_details.folio_number; 

. how can combine 3 queries without affecting attachment capability?

i'm assuming cfullpath attachment field?

if that's true, believe can append .filename attachment field display path in query

client_details.cfullpath.filename