Re: Antwort: SQL select subquery
1999-07-22 13:18:33
works for me (aix 4.2.1 adsm 3.1.2.15)
From the reference book sample:
adsm> select node_name from nodes where domain_name='UNIX' and -
cont> node_name not in (select node_name from associations -
cont> where domain_name='UNIX' and schedule_name='WEEKDAYBACKUP')
NODE_NAME
------------------
Node1
Node1
Node2
....
Richard
|
|
|