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
- 1892 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Rich man keeps me in the pocket poor man throws me away kids eat me its tamil word _u_e_l who am i?
26 Answers ASCO Numatics, Balaji, Cauvery, College School Exams Tests, HM, IBM, ICICI, Infosys, MCIS, Monster, Mphasis, NIT, PSC, Rajiv Gandhi University of Knowledge Technologies RGUKT, Srikara Hospitals, TATA, TCS, Tech Mahindra, TVS, Wipro,
oyou r in technical field thn why u r coming to the banking area???
1 Answers State Bank Of India SBI,
• What are the different Exchange 2003 versions
how i have to start personal interview i mean to say we have to mention over strength or weekness?
78 divided by 5 divided by 0.5
Dapat ba o hindi dapat ang relasyon ng parehong babae?
what is ur job profile.so describe how i will give the answer. i am student of m.b.a.
WHAT DO YOU KNOW ABOUT GENPACT
hello frnds,I am B.E graduate and also worked 5 yrs in real state sector as an engineer.I want to come in Gov.SEC.I cleared SBI cleark 2009 exam 1st round.Pls send me some question that can be asked in interview.I have to clear the interview dear ,no other way.Pls help me.God will blesss u for this help.need IMMEDIATE RESPONSE,PLS.
0 Answers State Bank Of India SBI,
what would be the two fractions of 100 ? there must be a difference of 1 between both fraction ???????
hi all i am an enginering graduate curently working with a ps u in nontechnical department and wish to change to a techinical department ,got thru open written test, going to appear for the personal interview.could be pls give the best reply for the question "WHY DO YOU WANT TO LEAVE YOUR CURRENT JOB AND JOIN US"?In my cast my current and future employer going to be same.
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
Energy Oil Gas 
