how to write a dynamic query for joining specified tables?
Table relations are
Department table have empid foreign key->employee table have id primary key
Employeelicences table have empid foreign key
for Example :
Employee table is join to department and Employeelicences is join to employee table
if we pass in where cause Employee and department
tables
employee table and department table will be joined
but i am getting employeelicences table also joining
how to fix this problem
can you please help me
Bhuvanesh MohankumarPosted May 4, 2016, 3:57 AM
Employee Table - EMPID [PK]
Department Table - EMPID[FK]
Nishant MittalPosted May 4, 2016, 2:21 AM