Re: Help with join

2004-02-10 Thread goran
try this select e.node_name,n.contact from events e , nodes n where ... - Original Message - From: "Lee, Gary D." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 09, 2004 7:19 PM Subject: Help with join Trying to create a select to give me th

Re: Help with join

2004-02-09 Thread Jim Neal
terpreted as an official opinion of any organization unless otherwise specified* -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Lee, Gary D. Sent: Monday, February 09, 2004 10:19 AM To: [EMAIL PROTECTED] Subject: Help with join Trying to create a select

Help with join

2004-02-09 Thread Lee, Gary D.
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