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
- 2352 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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 can you drop a raw egg on cemented fllor without breaking it ?
Dapat ba o hindi dapat ang relasyon ng parehong babae?
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
WHEN WILL BE THE INTERVIEW RESULTS FOR SBI ASSOCIATE BANK DECLARED?
i m selected for sbi clerrk and my interview in may-2010 . i m final year mca student so i want to know i show my mca in interview or not what are its effect in clerk interview
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,
• What are the different Exchange 2003 versions
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?
how we introduce infront of hr?
Hai guys, Iam adding some questions over here. Which may help us in the interview. 1.What is mixed economy? 2.What are the subsidories of SBI? 3.Who will issue currency notes? 4.What is meant by clearing house? 5.American express? 6.Which subsidory recently amalgamated in SBI? 7.What is meant by censex? 8.which bank recently submerged in SBI?
5 Answers State Bank Of India SBI,
What the tentative date of joining for 11th sbi po 2009 best
41 Answers State Bank Of India SBI,
Energy Oil Gas 
