Re: SELECT Statement
2007-02-07 07:46:51
> 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.
|
|
|