When you write SELECT statement and use column alias always use AS followed by Alias name. If you miss out a comma between column names, you will get different result sets with different column names
Consider the following set of code
create table #employee_master(emp_id int, emp_name varchar(100), dob varchar(12))
insert into #employee_master
select 1,'Sankar','09/19/1976' union all
select 2,'Kamal','02/11/1968' union all
select 3,'Rajesh','22/29/1200'
Select emp_id, emp_name dob from #employee_master
Note that there are three columns in the SELECT statement and there is a missing comma between emp_name and dob. If you execute the above code, the result is
emp_id dob
----------- -------------
1 Sankar
2 Kamal
3 Rajesh
If you look at the result , there are only two columns and under the column dob the names are displayed. Because in the SELECT statement emp_name dob is actually considered as emp_name as dob and dob becomes the alias name for emp_name.
You should be aware of this. If your SELECT statement has many column names always make sure there is no missing comma. If there is, make sure if it is a proper alias name and use AS between column names