Re: SQL Question

On Fri, Jan 06, 2006 at 04:02:53PM -0800, operationsengineer1@yahoo.com wrote:
> t_sn
> sn_id
> sn
>
> t_inspect
> inspect_id
> sn_id (fkey)
> inspect_pass (boolean)
>
> i want to display all sns where there is not a single
> instance of inspect_pass = t

There are several ways to do this, e.g., a query with NOT IN or a
join with a COUNT or SUM aggregate and a HAVING clause.  What have
you tried so far?

--
Michael Fuhr