Error:
Msg 4104, Level 16, State 1, Line 28
The multi-part identifier "idd.key" could not be bound.
Reason:
This Error Comes because the alias you are using in query is invalid/ Wrongly text type/ or not define.
Solution:
Check that alias you are using in projection and selection is available or not.
select e.ename, d.dname
from emp e
join
dept dd
on e.deptno = d.deptno
From above example you can see that the in Projection/Selection we are using "d" alias, where as on other hand we have defined the "dd" alias of table "dept".
Msg 4104, Level 16, State 1, Line 28
The multi-part identifier "idd.key" could not be bound.
Reason:
This Error Comes because the alias you are using in query is invalid/ Wrongly text type/ or not define.
Solution:
Check that alias you are using in projection and selection is available or not.
select e.ename, d.dname
from emp e
join
dept dd
on e.deptno = d.deptno
From above example you can see that the in Projection/Selection we are using "d" alias, where as on other hand we have defined the "dd" alias of table "dept".
No comments:
Post a Comment