Satish Vellanki

Satish Vellanki

  • NA
  • 6
  • 1.6k

SQL big DOUBT and also Dynamic Query

May 5 2016 5:33 AM
      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)