SQL big DOUBT and also Dynamic Query

Question

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

Bhuvanesh Mohankumar · Answer

Hi Sakthi 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 Better you write mutiple select Queries as per your logic and post here then we will make it with proper join because I can't figure out teh appropiate logic you are trying to achieve. Write the query like this SELECT * FROM DepartmentDetail WHERE DepartmentDetail.Id in (SELECT DepartmentDetailID FROM DepartmentDetail WHERE Employee.ID in (SELECT Employee.ID FROM Employee ) ) Something like this which satisfies your logic and output you required.

Satish Vellanki · Answer

Hi Pankaj If you don't pass any table name all tables will join based on relation ship if you pass no relation table name it join based on indirect relation ship tables

Pankaj Kumar Choudhary · Answer

Hello! Satish i think some information is missing in your query. Like if you don't pass any table name then what query you want . if you pass only single table name like EMPLICENSE table then what will be the query...... So clear these doubts then i can try to create a query....... Thanks..