Yes, it is very possible. These are most of the supported verbs from the help. There are predicates that are not listed here. If you do a HELP SELECT you get this:
The SELECT command supports the following expressions, clauses, functions, and predicates: ALL CURRENT_USER MAX ANY DISTINCT MIN AVG EXISTS NULL AS EXTRACT ORDER BY BETWEEN FROM POSITION CASE GROUP BY SOME CAST HAVING SUBSTRING COUNT IN SUM CURRENT_DATE JOIN TRIM CURRENT_TIME LIKE WHERE CURRENT_TIMESTAMP -----Original Message----- From: taford [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: Re: Select Stmts. in TSM I don't believe it's possible. I've researched this too. If anyone else has found otherwise, please let me know. Timothy A. Ford, MCSE LAN Services Micron Technology, Inc. -----Original Message----- From: Peppers, Holly [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 10:43 AM To: [EMAIL PROTECTED] Subject: Select Stmts. in TSM Has anybody tried to do a join in the TSM tables? I went looking thru the help utility and the manuals, but did not see the syntax of how to do this. Let me know please. Thanks. Holly L. Peppers Blue Cross & Blue Shield of Florida [EMAIL PROTECTED] Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.