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  

---

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?

9 Answers  

---

Solv this - i live in water, if u cut my head i am at ur door.if u cut my tail i m a fruit. i u cut both then i m with u, give me an asnwer

3 Answers  

---

I Need Change For 100 Rs It Should Not Be 2 Rs Notes But It Should Contain 50 Notes, Any Ideas?

8 Answers  

---

As stated in the job offer notification, is our basic salary of AED 29,500, good for you if employed?

0 Answers  

---

You are a software engineer.And your first project in our company is to design a submarine engine(about which you donot know about anything).Your team members were nothing but III standard students.....Will you take up this project? If so how you will manage it?

11 Answers   HCL,

---

Who is the author of the famous classical book "A Passage To India" ?

2 Answers   Wipro,

---

Please brief future of ayurveda.

1 Answers  

---

what is young one of a fish called ?

14 Answers  

---

my 1st friend gave me 1000 and 2nd gave me 500 i have loos 1000 rupees then i purchase some thing with the cost of 300 and gave 100 100 both friends 1st friend remaining 900 and 2nd remaining 400 900+400+300=1600 why

2 Answers   BPO, College School Exams Tests, Infosys,

---

who played the character langda tyagi in the film omkara?

1 Answers  

---

Please translate it in english... "Sivaji production-ku chandramuki ethanavathu padam"......How to ask this in english.......

9 Answers  

---