This should give you what your looking for:

select node_name as "Nodes Not Associated" -
 from nodes -
 where node_name not in -
 (select node_name from associations)

best regards
Hans-Jørgen Bergmann
Total Storage Solutions AS
hjb AT tssnordic DOT com

ons, 07.02.2007 kl. 13.29 +0100, skrev Herrmann, Boris:
> Hi all,
>  
> I have a select statement which shows me all nodes with corresponding 
> "active" (associated) Schedules:
> select n.node_name, n.domain_name, n.option_set, a.schedule_name from nodes 
> n, associations a where n.node_name=a.node_name
>  
> Now I want also a select statement which shows me all the nodes which haven't 
> any associated Schedules. How could I do that?
>  
> Any help are appreciate.
>  
> Mit freundlichen Grüßen / With kind regard,
> 
> ______________________________________
> 
>  
> 
> Boris Herrmann
> 
> Produktion / Heterogene Systeme 
> 
>  
> 
> ARAG IT GmbH
> 
> ARAG Platz 1, 40472 Düsseldorf
> 
>  
> 
> Tel:  +49 (0)211 964-1137
> 
> Fax: +49 (0)211 964-1155
> 
> Boris.Herrmann AT ARAG DOT de
> 
> www.ARAG.de <http://www.arag.de/> 
> 
>  
> 
> 
> 
> Geschäftsführer:  Ottmar Liebler, Hanno Petersen 
> 
> Sitz und Registergericht:  Düsseldorf,  HRB 10934
> 
> USt-ID-Nr.:  DE 119 356 473
> 
>  
>