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..

SQL big DOUBT and also Dynamic Query

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)