I have a table named mstemployee which contain all details of employee. with c

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

Question Posted / haianaz

0 Answers
2394 Views
I also Faced
E-Mail Answers

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Funny Interview Questions Interview Questions

Don't you feel embarrassed with your typos and your awfully written English, guys?

1 Answers

what is your passion

2 Answers HCL, TCS,

who invented vacuum cleaner?

1 Answers

Hi I worked in domino's pizza for five years from starting junior level to senior assistant manager level I left the job due to some health issues but till 8month I haven't joined in any company soo few months back I got a opportunity to work in cafe coffee day as a cafe manager But here I'm getting less salary then previous one due to I not got any job do 3rd soo long ago I joined in coffee day for less salary now I am not feeling too good to work here soo now I want to try some other job like in fashion or beauty industry but when I went for a interview The all interviewer are asked only one question like y u want to leave this current job it's not been completed three months also by working there and another critical question is y u joined such a low salary soo I was really got blank on this questions Will somebody help me out to what should I answer them and what career should I choose

1 Answers CCD,

WHY DO YOU WANT TO JOIN OUR ORGANIZATION?

2 Answers 247Customer, Genpact, Pharma,

how we introduce infront of hr?

1 Answers DELL, TCS,

REASON WHY YOU HAVE CHOSEN I.T. BRANCH?

4 Answers Wipro,

what is young one of a fish called ?

14 Answers

what is the full form of ANSWER?

1 Answers

When we have 24hour a day, why do we have to have 12hour a day clock design.