如何重命名联合查询中的列？

Hello I have the following query where I want to select the client from the clients table and the values statuses and currencies from the settings table. I made this query but is not working for the reason that both tables, client's and settings' have a column with the name id.Hello I have the following query where I want t