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
- 2363 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
A funny thing happened to me at a Group Discussion... And I got out of it in an even funnier way... Do check this out...
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
how many mapping can be done in One day at client place?
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,
WHEN WE SEARCH FOR ANY LOCATION EXM. (ALMORA) AND I HAVE TO ADD MY C.V IN ALMORA PORTAL. SO HOW CAN IT POSSIBLE?
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
who is the founder of pataliputra?
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?
why ibm ? give me exact answer
oyou r in technical field thn why u r coming to the banking area???
1 Answers State Bank Of India SBI,
when you got bycycle for the first tym?
Who is the author of the famous classical book "A Passage To India" ?
Energy Oil Gas 
