Re: Help with join
2004-02-10 03:07:40
try this
select e.node_name,n.contact from events e , nodes n where ...
----- Original Message -----
From: "Lee, Gary D." <GLEE AT BSU DOT EDU>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Monday, February 09, 2004 7:19 PM
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
|
|
|