Hi all,
I have create a simple query on dept and employee tables on emp.dept_id == dept.dept_id.
Now I have created a view and dragged the simple query to Meta data of view. I have added fields of view from
emp and dept table.
Now if try to open the view it is showing error.
Error:
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'EMP_NAME'.
It is showing results when fields only from dept or emp table . But when I mix dept and emp table fields following error shown.
*This post is locked for comments
I have the same question (0)
