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
Loading
karthik parchaPosted Dec 14, 2011, 2:44 AM
I want to show output like
EmpId,Empname,Designation ,ManagerId
this is the last query of my previous post
select * from Employee where ManagerId='WAD'//placing ManagerID to get Designation of sales rep belongs to VPsales
what ever the data comes through this query just i want insert into another temp table so i can join this table to my sp
thanks
karthik
Pravin GhadgePosted Dec 14, 2011, 2:08 AM
wat will be the final o/p that u want to show?