Not quite sure why that query is not working, but LEFT OUTER JOIN works fine for me:
SELECT n.node_name FROM nodes n LEFT OUTER JOIN filespaces f ON n.node_name=f.node_name WHERE f.node_name IS NULL On Tue, Aug 23, 2016 at 12:58:47PM +0000, Loon, Eric van (ITOPT3) - KLM wrote: > Hi David! > Your query doesn't work either. I was puzzling too with Shawn's SQL query and > I don't understand why it isn't working. > Kind regards, > Eric van Loon > Air France/KLM Storage Engineering > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of > David Ehresman > Sent: dinsdag 23 augustus 2016 14:13 > To: [email protected] > Subject: Re: Basic select help > > I think this should do what you want: > > select node_name from nodes where node_name not in (select node_name from > filespaces) > > David > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of > Shawn Drew > Sent: Monday, August 22, 2016 8:00 PM > To: [email protected] > Subject: [ADSM-L] Basic select help > > I am trying to get a list of nodes that have no filespaces and I am getting > stuck on what seems to be a very basic select statement. Can someone tell me > where I am going wrong? > The way I understand it, the select should at least show the node I just > created with no filespaces. > > > tsm: TSM1500>reg n shawntest xxxx do=admin userid=none ANR2060I Node > SHAWNTEST registered in policy domain ADMIN. > > tsm: TSM1500>select node_name from nodes where node_name NOT IN (select > distinct(node_name) from filespaces) ANR2034E SELECT: No match found using > this criteria. > ANS8001I Return code 11. > ******************************************************** > For information, services and offers, please visit our web site: > http://www.klm.com. This e-mail and any attachment may contain confidential > and privileged material intended for the addressee only. If you are not the > addressee, you are notified that no part of the e-mail or any attachment may > be disclosed, copied or distributed, and that any other action related to > this e-mail or attachment is strictly prohibited, and may be unlawful. If you > have received this e-mail by error, please notify the sender immediately by > return e-mail, and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its > employees shall not be liable for the incorrect or incomplete transmission of > this e-mail or any attachments, nor responsible for any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > ******************************************************** > -- -- Skylar Thompson ([email protected]) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine
