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
- 1872 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Please translate it in english... "Sivaji production-ku chandramuki ethanavathu padam"......How to ask this in english.......
wt is your funniest moment in your life
consider a simple java progarm(say hello world program),how the program is running without creating the object?(every class is accessed with the help of object). but ,how is this program running ??
If u are given candles which takes exactly one hour to burn completely than how will you measure one and half hour...
what type of question ask from hobby 'reading newspaper'
The area of BODO insurgents
who is founder of AITUC? (A) LALA LAJPAT RAI (B) M N ROY (C) N M JOSHEY
Do you invest in the stock market? What kind of investing strategy do you use if you do?
i m selected for sbi clerrk and my interview in may-2010 . i m final year mca student so i want to know i show my mca in interview or not what are its effect in clerk interview
12.22+ 22.21 + 221.12 = ?
WHAT'S YOUR HOBBIES?
how many states in india
Energy Oil Gas 
