All,

Seems that the order you specify tables in an SQL query is important.  I'm 
running TSM 5.1.6.1 on AIX 5.1.  I wanted to query volhistory and backupset 
tables:

tsm: SM040>select VOLUME_NAME, location, backupset_name from BACKUPSETS, 
VOLHISTORY where BACKUPSETS.DATE_TIME = VOLHISTORY.DATE_TIME

VOLUME_NAME            LOCATION               BACKUPSET_NAME
------------------     ------------------     ------------------
A00249                                        HKGIICOREP1.20030-
                                               805.77813798

tsm: SM040>select VOLUME_NAME, location, backupset_name from volhistory, 
backupsets where BACKUPSETS.DATE_TIME = VOLHISTORY.DATE_TIME
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.

tsm: SM040>

The first result is the result I wanted.

Why is the order of tables important?  Is this documented somewhere?  I'm 
concerned that I may not be getting correct data in other queries I run.

Mark




--
Mark Ferraretto
Unix Systems Administrator
Deutsche Bank Hong Kong
w: +852 2203 6362        m: +852 9558 8032        f: +852 2203 6971
mark.ferraretto AT db DOT com


--

This e-mail may contain confidential and/or privileged information. If you are 
not the intended recipient (or have received this e-mail in error) please 
notify the sender immediately and destroy this e-mail. Any unauthorized 
copying, disclosure or distribution of the material in this e-mail is strictly 
forbidden.