Again, based solely on the initial post with a little more data added:
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 UNION ALL
SELECT 3, 7, 1 UNION ALL
SELECT 3, 8, 1 UNION ALL
SELECT 3, 9, 1
GO
SELECT
*
FROM
#tblBlocks tb1
WHERE
NOT EXISTS(SELECT
1
FROM
#tblBlocks tb2
WHERE
tb2.BlockID = tb1.BlockID AND
tb2.BaseStage = 0);
go
--SELECT * FROM #tblBlocks
DROP TABLE #tblBlocks
go