Query for selecting a particular person?

Dear try this

Select EmpId , EmpName From EmployeeMaster Where EmpId Not In (SELECT EmpId From AllocationTable Where DateTime ='GetDate' )


You can get UnAllocatted Employee Using This Query For PArtucaular Day You can also pass data instead of "Getdate"

hi MohanRaj,

First we required table structure which is used by you.
after that we able to write query for you.

Or You required any input for design table?
thx.

Have 2 tables.

Table -Employee
ID, -EMployee Id
Name-Employee names

Table- Allocation
ID -Foreign key ref
Date- For each date
Status- Allocated(Y) or Not(N).


to find empl allocated:
Select * from Employee where id in (select id from Allocation where date ='' and status='Y'))

to find those who are not allocated
Select * from Employee where id in (select id from Allocation where date ='' and status='N'))