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
30
plz send me material 4 PO exam at amit_blz@yahoo.co.in
THANX
33
Please translate it in english... "Sivaji production-ku
chandramuki ethanavathu padam"......How to ask this in
english.......
40
REASON WHY YOU HAVE CHOSEN I.T. BRANCH?
42
What is your target in life?
what is your career objective?
To Refer this Site to Your Friends 
Site Map