On 25 July 2001, Gerardo Zapata wrote:
> 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
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 fr
