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
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
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