Ok here goes:
I have a table with id ( can be duplicate but not NULL ) and value ( can be duplicate and NULL )
id value
----- -----
1 red
1 red
1 (null)
2 blue
2 blue
3 (null)
So how do I return the id's and value's of all the records that have a value, but if a null value is also found don't include it in the result set.
So the return would be
id value
----- -----
2 blue
as id 1 and 3 have a value of (null) in one or more of the results