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:  laurakev13 AT yahoo DOT com
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Skylar Thompson
Sent: Saturday, March 13, 2010 7:38 PM
To: ADSM-L AT VM.MARIST DOT EDU
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 (skylar2 AT u.washington DOT edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S048, (206)-685-7354
-- University of Washington School of Medicine