```
SELECT user_id as user_id, CONCAT(first_name,' ',last_name) as name
FROM users u
WHERE (first_name like '%r%' or last_name like '%r%') 

UNION

SELECT provider_id as provider_id, provider_name as name
FROM providers
WHERE ( provider_name like '%r%')

```

Using the above query i get 

```
user_id name
5        Richard
6        Rowen
12       Riley
21       Rowen providers

```

Rowen providers has a provider\_id which is 21. but the column name is user\_id. How can i get a different column name for provider\_id ?