Getting error: Ambiguous column name 'ecode'

Hi,

Both the table containing ecode column, so you have to mention in your query, from which table you need values from ecode  column.

So removing this error either use a.ecode or b.ecode

Select top(20) sno,a.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