Hi Justin,

If I understood you correctly, try something like this:

select a.schedule_name, a.node_name, b.contact from associations a, nodes b 
where a.node_name = b.node_name order by b.contact,a.node_name

Good luck

Joe Crnjanski
Infinity Network Solutions Inc.
Phone: 416-235-0931 x26
Fax:     416-235-0265
Web:  www.infinitynetwork.com



-----Original Message-----
From: Justin Bleistein [mailto:justin.bleistein AT SUNGARD DOT COM]
Sent: Tuesday, December 30, 2003 12:44 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: tsm select statement help


Does anyone have an sql syntax/statement example on how to join two sql
tables in adsm/tsm?
I have two tables in that adsm schema which both contain info that the
other doesn't respectively.
So I want to join them to get the desired results. I'm looking at Oracle
examples on the web none
really good. Any assistance would be appreciated. I know I could figure it
out but if someone could
save me trial and error time. I would really appreciate it..
Thanks in advance.

--Justin Richard Bleistein
Unix/TSM Systems Administrator