Try this:

CREATE TABLE #tblBlocks

(

BlockID int,

FieldID int,

BaseStage bit

)

GO

INSERT INTO #tblBlocks (BlockID, FieldID, BaseStage)

SELECT 1, 1, 0 UNION ALL

SELECT 1, 2, 0 UNION ALL

SELECT 1, 3, 0 UNION ALL

SELECT 2, 4, 0 UNION ALL

SELECT 2, 5, 1 UNION ALL

SELECT 2, 6, 0

GO

SELECT

*

FROM

#tblBlocks tb1

WHERE

NOT EXISTS(SELECT

1

FROM

#tblBlocks tb2

WHERE

tb2.BlockID = tb1.BlockID AND

tb2.BaseStage = 1);

go

--SELECT * FROM #tblBlocks

DROP TABLE #tblBlocks

go