If I am wrong about the IN clause, please let me know.
Teddy
On 8/9/06, Ryan Guill <[EMAIL PROTECTED]> wrote:
I dont know how you would do it in reactor, but this may help you find
it, you could rewrite that query with an exception join:
Select appUser.*
from AppUser
Exception Join training
on userid = userid
On 8/9/06, Brad Haas <[EMAIL PROTECTED]> wrote:
>
>
> How would I do this in Reactor:
>
> SELECT AppUser.*
> FROM AppUser
> WHERE UserID NOT IN
> (SELECT UserID
> FROM Training)
>
>
> I suspect you'd use some type of outer join, but could someone show me some
> reactor code how to accomplish this?
>
> Thanks,
> Brad
>
>
>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
> Reactor for ColdFusion Mailing List
> [email protected]
> Archives at:
> http://www.mail-archive.com/reactor%40doughughes.net/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
--
Ryan Guill
A Deep Blue
[EMAIL PROTECTED]
www.ryanguill.com
(270) 217.2399
got google talk? Chat me at [EMAIL PROTECTED]
Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/
www.ryanguill.com/
The Roman Empire: www.ryanguill.com/blog/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
<cf_payne />
http://cfpayne.wordpress.com/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
