Re: Help with join
2004-02-09 14:25:17
Hi Gary,
I'm not sure if your e-mail contains typos or not, but the first thing
that
I noticed is that you do not have a comma separating the selected fields i.e
"select events.node_name, nodes.contact from events nodes where". If you do
have the commas separating the selected fields please let me know and I will
attempt to assist further.
Jim Neal
Junior Engineer
Lockheed-Martin IT/ODIN
AMES Research Center
Moffett Field, Ca 94035
(650) 604-1283
*Any comments, posts, or other e-mail sent from this address are the opinion
of the sender and should not be interpreted as an official opinion of any
organization unless otherwise specified*
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Lee, Gary D.
Sent: Monday, February 09, 2004 10:19 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Help with join
Trying to create a select to give me the contact info for all nodes whose
schedules did not complete the previous night.
Figured to join the events and nodes tables. A screen dump from the admin
client where I am experimenting follows.
Any help appreciated.
tsm: SPOCK-S1>select events.node_name nodes.contact from events nodes
where -
cont> events.node_name=nodes.node_name and events.status!='Completed'
ANR2905E Unexpected SQL identifier token - 'NODES.CONTACT'.
|
........................V......................................
select events.node_name nodes.contact from events nodes where e
ANS8001I Return code 3.
Gary Lee
Senior Operating Systems Analyst
Ball State University
phone 765-285-1310
|
|
|