riya_dave (7/10/2013)
i can see that column name in my table.also when i type alias my intellisense for that table doesnt get anything, if i type anoter table name
it display all the fields for that table?
You need to post accuratly complete query you're written.
The one posted:
select ra.column, r1,column2
from emp ra inner join
emp1 r1
on r1.empid = ra.empid
has a comma instead of dot between "r1" and "column2" in a select line, which would cause another errorr.
Can you also post DDL for your "emp" and "emp1" tables