Laura Lantz is no longer with OBI.  Please send email to the following
address and/or remove her from your distribution list.  This mailbox
will be closing effective March 18.  Thank you.  

Laura's email address is:  [email protected]
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of
Skylar Thompson
Sent: Saturday, March 13, 2010 7:38 PM
To: [email protected]
Subject: Re: finding out if a node is associated with a schedule

This ought to do the trick:

select nodes.node_name from nodes where nodes.node_name \
   not in (select associations.node_name from associations)

yoda woya wrote:
> using sql, how do i find out the do nodes that are not associated with
a
> schedule
>   

-- 
-- Skylar Thompson ([email protected])
-- Genome Sciences Department, System Administrator
-- Foege Building S048, (206)-685-7354
-- University of Washington School of Medicine

Reply via email to