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:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of David Ehresman
> Sent: dinsdag 23 augustus 2016 14:13
> To: ADSM-L AT VM.MARIST DOT EDU
> 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Shawn Drew
> Sent: Monday, August 22, 2016 8:00 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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 (skylar2 AT u.washington DOT edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine
|