3
Reply

SQL big DOUBT and also Dynamic Query

Satish Vellanki

Satish Vellanki

May 5 2016 5:33 AM
315
      IF I PASS DEPATMENTDETAILS TABLE AND EMPLICENSE TABLE IN WHERE CAUSE ?
OUTPUT QUERY IS  
select * from DepartmentDetail inner join Department on DepartmentDetail.Id=Department.DeptId inner join Employee on   Employee.Id=Department .EmpLicense.Id inner join EmpLicense on EmpLicense.Id=Employee.EmplolyeeId
like this i want
 

Answers (3)