SQL Developer duplicate column name while creating view

Question

I am getting this error while running statement specified below

ORA-00957: duplicate column name
00957. 00000 - "duplicate column name"

My query:

create view vw_sales_may 
as 
    select 
        customers.id, orderdetails.id, sales.sale_date, sales.total_value 
    from 
        customers 
    inner join 
        sales on customers.id = sales.customer_id 
    join 
        orderdetails on orderdetails.customer_id = customers.id 
    where 
        to_char(sale_date, 'MM') = 05;

JonTout · Accepted Answer · 2022-06-03 17:35:55Z

1

Just need to add column aliases.

create view vw_sales_may as 
select customers.id as CustomerID, 
orderdetails.id as OrderDetailsID, 
sales.sale_date, 
sales.total_value 
from customers 
inner join sales on customers.id = sales.customer_id 
join orderdetails on orderdetails.customer_id = customers.id 
where to_char(sale_date,'MM') = 05;

answered Jun 3, 2022 at 17:35

JonTout

6406 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Developer duplicate column name while creating view

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related