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
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
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)How to post your question to get the best and quick help