Pranjal Mishra

Pranjal Mishra

  • NA
  • 59
  • 47.6k

Getting error: Ambiguous column name 'ecode'

Dec 31 2012 10:33 PM
Select top(20) sno,ecode,name,mobile_no,department,doj,ctc
from charbi..mst_emp_master(nolock)a
inner join charbi..new_emp_salary_master(nolock)b
on a.ecode=b.ecode 
where status='Y'
order by doj  desc




i m getting error as




Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'ecode'.



pls let me know what im doing wrong.

Answers (2)