4 messages in com.mysql.lists.win32Re: select question
FromSent OnAttachments
Frank Tudor29 Apr 2004 08:37 
Ignatius Reilly29 Apr 2004 09:02 
Frank Tudor29 Apr 2004 09:11 
Graeme St.Clair29 Apr 2004 09:52 
Subject:Re: select question
From:Frank Tudor (fran@yahoo.com)
Date:04/29/2004 09:11:15 AM
List:com.mysql.lists.win32

This did it!!!!

:)

Thanks!

Frank

--- Ignatius Reilly <igna@free.fr> wrote:

WHERE page.pageid BETWEEN 1 AND 10

_________________________

Here is a sql statment I need modified.

select sum(duration)/60 from course_material where section = '1';

There are also course pages in a table called pages and these pages are numbered 1 throuh 20.

If I neded to grab pages one through 10 what would the sql look like?

So logic:

where pages are between 1 and 10

how would I do this?

thanks, Frank