Hello Andy,

thanks!! That's it. Now I've 100% the output I have searched for ;-)


Mit freundlichen Grüßen / with kind regards,
____________________________________________
 
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
 
 
Geschäftsführer:  Ottmar Liebler, Hanno Petersen 
Sitz und Registergericht:  Düsseldorf,  HRB 10934
USt-ID-Nr.:  DE 119 356 473
 


-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag 
von Andrew Raibeck
Gesendet: Mittwoch, 7. Februar 2007 13:48
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: [ADSM-L] SELECT Statement


> Now I want also a select statement which shows me all the nodes which 
> haven't any associated Schedules. How could I do that?

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

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page: 
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.