how to use union on two tables

Select e.employeename 
from employee e join timesheet t 
where e.employeeid=t.employeeid
and t.startdate is null 
or t.enddate is null

Hey,
Try this

select employeename from employee emp inner join timesheet ts on emp.employeeid =ts.employeeid
where startdate=null or enddate=null

Good Luck

Hi...!
click the link and u will found how to use UNION OR UNION ALL Operator in your project..!
http://www.mssqltips.com/sqlservertip/1387/joining-data-using-union-and-union-all-in-sql-server/[^]

Hi Mayank,

This might help you

Table1 - Timesheet
Columns - employeeid, startdate, enddate

Table2 - employee
Columns - employeeid,employeename


this is a query you can perform - query format [SQL SERVER]

SELECT DISTINCT e.employeeid,e.name
FROM employee e
left outer join timesheet t on t.employeeid = e.employeeid
where t.startdate != N'2012-01-01' OR t.enddate != N'2012-01-01'

In the above statement in WHERE clause change OR -> AND according to your requirement.

Hi, use below query

Select e.employeename 
from employee e join timesheet t 
where e.employeeid=t.employeeid
and (isnull(t.startdate,'') = '' 
or isnull(t.enddate,'') = '' )

Hopefully, It will solve your problem. :-)