HI, I'M TRYING TO ELABORATE AN SQL STATEMENT TO GET INFORMATION FROM TWO
DIFFERENT TABLES USING A SINGLE COMMAND.

THE OBJECTIVE IS TO DETERMINE THE NAME OF A VOLUME CONTAINING A SPECIFIC
ARCHIVE FROM A SPECIFICE NODE.

I USE THE FOLLOWING SQL TO GET THE DATA:

select volume_name,node_name,type from contents where node_name='MYNODE' and
type='Arch'

select node_name,archive_date,description from archives where
node_name='MYNODE' and description='Archive Date: 07/25/2001'

THE COMMON FIELD FOR BOTH TABLES IS 'NODE_NAME', HOW COULD I COMBINE THESE TWO
STATEMENTS TO GET THE NODE NAME, ARCHIVE DESCRIPTION, ARCHIVE DATE AND VOLUME
NAME USING A SINGLE SQL COMMAND.

THANKS IN ADVANCE
REGARDS

GERARDO ZAPATA 
TIVOLI IT SPECIALIST
I&SM
IBM MEXICO
gzapata AT mx1.ibm DOT com