Column names in each view or function must be unique. Column name ‘custid’ in view or function ‘mynameview’ is specified more than once

  Kiến thức lập trình

I have created two tables and i am trying to create a view by joining two tables using left outer join but i am getting
ERROR : Column names in each view or function must be unique. Column name ‘custid’ in view or function ‘mynameview’ is specified more than once.

This is the code i have implemented
(https://i.sstatic.net/65ek6mOB.png)[text]

this is the error msg
(https://i.sstatic.net/66ek6mOB.png)

  • sql-server

New contributor

Saurabh patil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

LEAVE A COMMENT