thanks!
tw
On Fri, 23 Jul 2004 10:02:00 -0400, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> Ohh... you only want records for orders that don't have any cancelled
> items in the order? ...
>
> yea, Tom's where not exists (...) syntax works nicely for SQL Server
> and Oracle -- don't know about access or mysql offhand.
>
>
> > On Friday 23 Jul 2004 14:30 pm, Tony Weeg wrote:
> >> is this possible in 1 query?
>
> > If you can do sub querys in your DB:
>
> > select *
> > from table a
> > where status=1 and not exists (
> > select id from table b where a.id=b.id and status is 0
> > )
>
> > --
> > Tom Chiverton
> > Advanced ColdFusion Programmer
>
> > Tel: +44(0)1749 834997
> > email: [EMAIL PROTECTED]
> > BlueFinger Limited
> > Underwood Business Park
> > Wookey Hole Road, WELLS. BA5 1AF
> > Tel: +44 (0)1749 834900
> > Fax: +44 (0)1749 834901
> > web: www.bluefinger.com
> > Company Reg No: 4209395 Registered Office: 2 Temple Back
> > East, Temple
> > Quay, BRISTOL. BS1 6EG.
> > *** This E-mail contains confidential information for the
> > addressee
> > only. If you are not the intended recipient, please notify
> > us
> > immediately. You should not use, disclose, distribute or
> > copy this
> > communication if received in error. No binding contract
> > will result from
> > this e-mail until such time as a written document is
> > signed on behalf of
> > the company. BlueFinger Limited cannot accept
> > responsibility for the
> > completeness or accuracy of this message as it has been
> > transmitted over
> > public networks.***
>
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]