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:[EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 12:44 PM To: [EMAIL PROTECTED] 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
