On 1/6/06, operationsengineer1(at)yahoo(dot)com <operationsengineer1(at)yahoo(dot)com>
wrote:
>
> and another sql question...
>
> greatly simplified info:
>
> 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
This should get you what you're looking for:
SELECT sn FROM t_sn
WHERE sn_id NOT IN
(SELECT sn_id FROM t_inspect
WHERE inspect_pass = t)
--
Stephen Clouse <stephenclouse(at)gmail(dot)com>