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
- 2367 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Do you invest in the stock market? What kind of investing strategy do you use if you do?
how many mapping can be done in One day at client place?
when you got bycycle for the first tym?
Dapat ba o hindi dapat ang relasyon ng parehong babae?
AS PER BUDGET 2007-08 HOW MUCH AMOUNT APPROXIMATELY THE GOVT OF INDIA IS PROVIDED FOR women specific schemes/programmes (approximately)?
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
What is your opinion on M S Dhoni retirement from test cricket?
20 apple 1 rupees(indian currency)1 orange 5 rupees and 1 lemon 1 rupee.i wan to buy 100 fruits(above mentioned)for 100 rupees. tell me how much quantity of apple orange and lemon will be buy for 100 rupees. this is serious qstn.help me plzz????????
I m allready working in nationalised bank as a clerk(3-4 month)in rajasthan(posted at home town). now i m selected in sbi for the post of clerk(punjab).. should i join sbi? is it right choice? i m very confused plz reply.
3 Answers State Bank Of India SBI,
HAI MY INTERVIEW IS ON 30TH APRIL I AM PASSED IN BSC MATHEMATICS WHAT TYPE OF QUESTIONS WILL BE ASK IN THE MATHEMATICS WHO ONE HAVE PASSED MATHEMATICS PLZ SEND YOUR IDEAS ....
what is the full form of ANSWER?
what is applet?
Energy Oil Gas 
