I have two tables A and B, and try to select them by sql `INNER JOIN`, but I run into this error:

> 
> ORA-00918: column ambiguously defined
> 
> 
> 

I guess it is because there are two columns' name in these two tables are the same, that is `A.column1`, `B.column1` and `A.column2` and `B.column2` (These two columns' name in A and B are the same). Since these two tables are stored in the server, I can not rename the columns. So what can I do?

This is the code I use:

```
Select * FROM A INNER JOIN B WHERE A.column1 = B.column1.

```

How can I fix it?