On Mon, Jun 18, 2012 at 6:26 PM, Matijn Woudt wrote:
> On Mon, Jun 18, 2012 at 11:56 PM, Dee Ayy wrote:
>> I would like a query that lists records where a column has not taken
>> on a specific value when grouped by another column.
>>
>> N V
>> n1 v1
>> n1 v2
>> n2 v1
>> n2 v2
>> n2 v3
>> n3 v1
>
On Mon, Jun 18, 2012 at 11:56 PM, Dee Ayy wrote:
> I would like a query that lists records where a column has not taken
> on a specific value when grouped by another column.
>
> N V
> n1 v1
> n1 v2
> n2 v1
> n2 v2
> n2 v3
> n3 v1
>
> If v3 has ever been set for N, do not list N. So the result wo
I would like a query that lists records where a column has not taken
on a specific value when grouped by another column.
N V
n1 v1
n1 v2
n2 v1
n2 v2
n2 v3
n3 v1
If v3 has ever been set for N, do not list N. So the result would be n1, n3
If v2 has ever been set for N, do not list N. So the res