Re: SQL omit record if ever had value set

On Mon, Jun 18, 2012 at 11:56 PM, Dee Ayy <[email protected]> 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 would be n1, n3
>
> If v2 has ever been set for N, do not list N.  So the result would be only n3
>
> MSSQL
>
> TIA
>

I guess this should work in MSSQL too:

SELECT N FROM table WHERE N NOT IN (SELECT N FROM table WHERE v = v3)

- Matijn

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php