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
- 1881 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
who is the founder of pataliputra?
who was the narrator of the film 'Jodha Akabar'?
why ibm ? give me exact answer
i have written an article on the subject - interviewing process going transitional - a survey. i need to get it published to a well known magazine of H.R related. Could you please let me know where i need to send them and at which email id. the persons name and the name of the publisher and their contact no. Find the glimse of the article being presented. On reviewing your article on survey interviewing procedure published recently on 23, 2011 and having gone through face to face interviewing process in many of the traditional & professional companies, I look forward and like to present some of the closest facts, which was never being disclosed earlier. This information may throb the corporate world of mid size ltd / pvt companies and may question their hiring process and take the matter to the interviewing board. You must have read in economics about five M- i.e. man, material , methods, money , market. When they are synthesize together, a better result is expected to enhance good health of the industry. There are some internal & external factors that influences the Hiring / Recruitment process & success of an organization, followed by some macro & micro factors that persuades our recruitment / employment policy. At the time of hiring a candidate, the selection’s are made based on some...... to be continued with attachments.......
what is applet?
What the tentative date of joining for 11th sbi po 2009 best
41 Answers State Bank Of India SBI,
Solve this, if u think.....u r brilliant..😇 1. I am a 8 letter Indian place. 2. Last 4 letters is first name of lady Tennis player. 3. 4,5,6 letters is used to carry goods and passengers. 4. 6,5,7,2,3 is a hill station . 5. This is a great place. No more clue... 🔧101% brain work. Reply.
The area of BODO insurgents
are movies for entertainment...?
how many states in india
Tell me about urs positive and negtive thinking?
how i have to start personal interview i mean to say we have to mention over strength or weekness?
Energy Oil Gas 
