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.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
