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