<p>Got into a situation where in a schema i have a table, say table ACTION , while i got a synonym called ACTION as well which refers to another table to another schema.</p>

<p>Now, when i run the query</p>

<p>select * from ACTION</p>

<p>it will select the records from the table, but not the synonym.</p>

<p>Anyway for me to select from the synonym AND the table both together?</p>

<p>Thanx</p>

Well, your underlying ACTION table should be renamed, let's say do LOCAL_ACTION.
Let's pretend your ACTION synonym is on otheruser.LOCAL_ACTION table...
Then you can redefine the ACTION synonym to be:
```
```
SELECT * from LOCAL_ACTION
UNION
SELECT * from otheruser.LOCAL_ACTION
```
```
Then in the end, select * from ACTION will give you a combined list of both tables.