was quick on the draw, thanks! all good.
got it working.
later, and btw, HAVE A GREAT! FRIDAY
On Fri, 23 Jul 2004 09:47:28 -0400, Tony Weeg <[EMAIL PROTECTED]> wrote:
> thomas aquinas something or other, you are a GEM!
>
> thanks
>
> select *
> from stgCRM_Orders a
> where status = 1 and not exists
> (
> select crmUUID from stgCRM_orders b where a.crmUUID=b.crmUUID and status = 0
> )
>
> was what i am finally using, and it works like a charm!
>
> thanks
> tony
>
>
>
> --
>
> tony
>
> Tony Weeg
> human.
> email: tonyweeg [at] gmail [dot] com
> blog: http://www.revolutionwebdesign.com/blog/
>
> Check out http://www.antiwrap.com to send websites to your friends.
>
--
tony
Tony Weeg
human.
email: tonyweeg [at] gmail [dot] com
blog: http://www.revolutionwebdesign.com/blog/
Check out http://www.antiwrap.com to send websites to your friends.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
