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.
