i need to add 1more field from emp1. but when i am trying getting error like 'The multi-part identifier "r1.emp2" could not be bound.'
The above means that there is no column named "emp2" in a table/view/subquery/anything else referenced by the alias "r1"
_____________________________________________
"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[/url]