Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2346 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
which movie was ferhan akhtar's dirocterial debut?
Anyone else in this world Ever Imgine about An Interviewer from A Consultancey Recruitment Agency and WHAT INTERVIEW HE/SHE FACED FOR THAT POST ? AND WHAT EDUCATIONAL QUALIFICATION THEY SHOULD HAVE ? Above all WHAT kNOWLEDGE THEY HAVE ?
vo kya cheez hai jo saal me ek bar, mahine me do bar,haphte me 4 bar or din me 6 bar aati hai..
7 Answers Airtel, Alok Industries, Coal India, IBM, Reliance, SSC,
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
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.
how many mapping can be done in One day at client place?
hi, i have passed bank of baroda clerical staff exam. i want to know the date of personal interview by the bank. i dont get the call letter from bank but my roll no is in the list of passed candidates list on bank of baroda website.
Please translate it in english... "Sivaji production-ku chandramuki ethanavathu padam"......How to ask this in english.......
WHAT IS THE NUMBER OF ATMs OF SYNDICTE BANK
what is the diffirence between tube and pipe
how can you drop a raw egg on cemented fllor without breaking it ?
oyou r in technical field thn why u r coming to the banking area???
1 Answers State Bank Of India SBI,
Energy Oil Gas 
