| Subject | JOIN on a SELECT Procedure |
|---|---|
| Author | Jem Rayfield |
| Post date | 2002-11-21T16:30:36Z |
Hi,
Just thought Id share my joy....
SELECT
*
FROM
USRS_NOT_LOGGED_IN_BY_GE_GM( '10/21/2002' ) UL LEFT OUTER JOIN USERS U
ON ( UL.UID = U.UID )
WHERE
U.USER_STATE <> 'ACTIVE'
Its possible to JOIN the result of a select procedure with a standard table..
You all probably new this but I am just well ... pleased.
Jem
--
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.
Just thought Id share my joy....
SELECT
*
FROM
USRS_NOT_LOGGED_IN_BY_GE_GM( '10/21/2002' ) UL LEFT OUTER JOIN USERS U
ON ( UL.UID = U.UID )
WHERE
U.USER_STATE <> 'ACTIVE'
Its possible to JOIN the result of a select procedure with a standard table..
You all probably new this but I am just well ... pleased.
Jem
--
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.