Trouble with UNION

I'm making some sort of mistake in the following code:

use xPress_CR
select * 
from 
	(SELECT * 
 FROM dbo.T_JOBS 
 WHERE ENDDATEANDTIME = null
UNION
SELECT * 
 FROM dbo.T_JOBS 
 WHERE STATUS = 'Failed')

Any idea what I'm doing wrong?

Junior Poster

154 posts since Nov 2009

Reputation Points: 10

Solved Threads: 1

no need to union

select * from dbo.T_JOBS where (STATUS = 'Failed' or ENDDATEANDTIME = NULL)

Nearly a Posting Virtuoso

1,306 posts since Dec 2008

Reputation Points: 257

Solved Threads: 270

Thx, works now.

Junior Poster

154 posts since Nov 2009

Reputation Points: 10

Solved Threads: 1

This question has already been solved

You