SELECT COUNT(WMS_Area.Area_ID) AS complete_areas FROM WMS_Area, WMS_Bookings 
WHERE WMS_Area.Area_ID = WMS_Bookings.Area_ID
AND MIN(WMS_Bookings.Booking_Status) = 2
GROUP BY WMS_Area.Area_ID


Or something like that.. there's probably a better way to do it.. 


On Fri January 23 2004 1:05 pm, Shaun wrote:
> Thanks for your reply,
>
> but that only tells me how many complete Bookings there are. I need to know
> how many Areas are complete i.e. for each Area where Bookings take place,
> all of those Bookings have been completed.
>
> Any ideas?
>
> "Oòvn?Oòsis" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>
> > Mensaje citado por Shaun <[EMAIL PROTECTED]>:
> > > Hi,
> > >
> > > I have a Bookings application. When a Booking is made it is entered in
>
> to
>
> > > the Bookings table. Bookings take place at Areas, held in the Areas
>
> table.
>
> > > Each Area has a unique Area_ID held in the Bookings table for each
>
> Booking.
>
> > > Each Booking needs to be completed and when done so the Booking_Status
>
> for
>
> > > each Booking is updated to '2'. An Area is complete when all Bookings
> > > at that
> > > Area have been completed. How can I run a query that tells me how many
> > > completed Areas there are in the system?
> >
> > SELECT count(*) FROM WMS_Bookings WHERE Booking_Status = 2;
> >
> > Saludos... :-)
> >
> > > Thanks for your help
> > >
> > > CREATE TABLE WMS_Bookings (
> > >   Booking_ID int(11)  DEFAULT '' NOT NULL auto_increment,
> > >   User_ID int(11)  DEFAULT '0' NOT NULL ,
> > >   Project_ID int(11)  DEFAULT '0' NOT NULL ,
> > >   Area_ID int(11)  DEFAULT '0' NOT NULL ,
> > >   Booking_Start_Date datetime  DEFAULT '0000-00-00 00:00:00' NOT NULL ,
> > >   Booking_End_Date datetime  DEFAULT '0000-00-00 00:00:00' NOT NULL ,
> > >   Booking_Completion_Date date    ,
> > >   Booking_Status int(2)  DEFAULT '0' NOT NULL ,
> > >   Additional_Notes text    ,
> > >   PRIMARY KEY (Booking_ID)
> > > );
> > >
> > > CREATE TABLE WMS_Area (
> > >   Area_ID int(11)  DEFAULT '' NOT NULL auto_increment,
> > >   Area_Name varchar(40)  DEFAULT '' NOT NULL ,
> > >   Area_Address varchar(255)  DEFAULT '' NOT NULL ,
> > >   Area_Postcode varchar(10)  DEFAULT '' NOT NULL ,
> > >   Area_Telephone varchar(15)  DEFAULT '' NOT NULL ,
> > >   PRIMARY KEY (Area_ID)
> > > );
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> > --
> > select 'mmarques' || '@' || 'unl.edu.ar' AS email;
> > -------------------------------------------------------
> > Martín Marqués          |   Programador, DBA
> > Centro de Telemática |     Administrador
> >                Universidad Nacional
> >                     del Litoral
> > -------------------------------------------------------

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to