SQL & PL/SQL

Hello,

I have two different tables that match some column names.

I want to select *(all) from both of them, so i do:

select q.*,h.* from dual q, dual h;

But now i need to have an 'outer' select to that:

select t.* from

(select q.*,h.* from dual q, dual h)t;

And this is giving error:

ORA-00918: column ambiguously defined

00918. 00000 - "column ambiguously defined"

The ambiguously defined column was solved in previous query.

I would like it to automatically concatenates the number with the column name as it does in first query.

Is there any way to achieve this?

I don´t even know how to search for this issue in order to find a proper solution.

Thanks for help

Regards,

Carlos

Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production