Want to build the ChatGPT based Apps? Start here
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Anjali Khan
1.4k
867
194.5k
my selfjoin query getting error
Mar 25 2018 11:34 PM
Hi frnds
Below my table
-----------------------------------------------------------
EmpId EmpName ManagerId
______________________________________
1 A 1
2 B 1
3 C 2
4 D 3
5 E 4
and my self join query is
select e1.EmpName as ManagerName, e2.EmpName as EmpName
from EmpTest
selfjoin EmpTest
On e1.EmpId = e.ManagerId
when i execute the query it is showing error like
Msg 102, Level 15, State 1, Line 6
Incorrect syntax near 'EmpTest'.
please provide the write ans
Reply
Answers (
6
)
How to find the domain in mail id?
How to convert rows to columns in sql server 2008