TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
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
Forums
Monthly Leaders
Forum guidelines
karthik parcha
NA
153
93.1k
Joins
Dec 14 2011 1:45 AM
Hi
This is my question :
For Vpsales there are some sales representatives are there so i have to write joins for that plz help me this is my query
plz help me or guide me
select EmpId from Employee where Designation='VP Sales' //here iam getting empid of one of the vpsales i.e 'SBR' am placing this Empid in Empuser table
select UserUniqueid from EmpUser where EmpId='SBR'//placing this Empid in Empuser table
iam getting useruniqueid of that empid
select ProjID from SF_PROJECTEMP where UserUniqueId in(1473,1474,1475,4877,4879)//placing useruniqueid to fet ProjId
selectManagerId from SF_Project where ProjId=476//Placing ProjID in this table to get ManagerID
select * from Employee where ManagerId='WAD'//placing ManagerID to get Designation of sales rep belongs to VPsales
SO how to write Joins for this whole query plz help me or guide me
thanks
Reply
Answers (
2
)
VPN on Windows 7
Store procedure in SQL server