Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table named mstemployee which contain all details
of employee. with column id,name
and another table named MessageList which contains columns
id,message,Toempid,sendTime,msgFromempid,Status
my problem is following
i get the following error message when i run the following
query
Tables or functions 'mstemployee' and 'mstemployee' have
the same exposed names. Use correlation names to
distinguish them.
QUERY.......................................
select message as Subject,mstemployee.name
TO_Name,mstemployee.name from_Name ,convert
(varchar,sendTime,103) as sendTime,MessageList.id as MsgID
from dbo.MessageList left join mstemployee on
mstemployee.id = MessageList.msgFromempid left join
mstemployee on mstemployee.id = MessageList.msgToempid
where MessageList.Status='Post' and MessageList.msgToempid=1
- 0 Answers
- 2320 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
I have a table named mstemployee which contain all details of employee. with column id,name and another table named MessageList which contains columns id,message,Toempid,sendTime,msgFromempid,Status my problem is following i get the following error message when i run the following query Tables or functions 'mstemployee' and 'mstemployee' have the same exposed names. Use correlation names to distinguish them. QUERY....................................... select message as Subject,mstemployee.name TO_Name,mstemployee.name from_Name ,convert (varchar,sendTime,103) as sendTime,MessageList.id as MsgID from dbo.MessageList left join mstemployee on mstemployee.id = MessageList.msgFromempid left join mstemployee on mstemployee.id = MessageList.msgToempid where MessageList.Status='Post' and MessageList.msgToempid=1
what is the full form of ANSWER?
who discover milk????
8 Answers State Bank Of India SBI,
in which sports left hand not used
Two persons on death bed, one is whom u love n anothr is who loves u. U can save only one. Whom would u n why?
What happens when one crosses 1800 longitude from west to east?
11 Answers Infosys, Kannan Systems,
how many states in india
The difference between a number and its three-fifth is 50. What is the number?
what is ur job profile.so describe how i will give the answer. i am student of m.b.a.
1 coconut cost rs 20 , 1 mango cost rs 1, 5 guava cost rs 1 ..try to get 100 fruits in rs 100 you have to have at least 1 of each fruit
3 question ka jawab bataye . In swaalo ke jwaab de diye to hm aapko whtsapp king kahenge.... Q- 1...Baap ne beti ko 1gift diya Or kaha bhuk lage to kha lena... Pyas lage to pi lena or thand lage to jala lena... ye gift kya he challenge for u !! "Challange For all group Time limit 1days . Q-2.....ek chij aeisi h jo sukhi ho to 2kg. gili ho to 1kg. or jal jae to 3kg. its challenge for u !! Q..3... Vo kya chiz hai jo saal me 1 bar, mahine me 2 bar, hafte me 4 bar, aur din me 6 bar aati hai..?
9 Answers Coconut Software, TATA,
are movies for entertainment...?
Energy Oil Gas 
