SELECT b.[someexistingcolumn] FROM (SELECT 1 AS [col]) AS a INNER JOIN [tblTable] AS b ON [a].[col] <> 0