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]
