SQL big DOUBT and also Dynamic Query

Satish Vellanki

10y1.1kSQL

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhuvanesh Mohankumar10y ago
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 Vellanki10y ago
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 Choudhary10y ago
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..